Microsoft KB Archive/128749

= Works: Database and Spreadsheet Sample Date Incorrect =

Article ID: 128749

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q128749



SYMPTOMS
When you choose Number from the Format menu in a Works spreadsheet or database, the example in the Options section of the Number dialog box may display the incorrect date when the Date format is selected. For example, an invalid date such as 12/31/1899 may be displayed.



CAUSE
This occurs if the current date in the Windows Control Panel is set to a value later than June 3, 2079.



RESOLUTION
Change the date in the Date/Time section of Control Panel to the current date.

For more information about how to perform this task in Windows, see your Windows printed documentation or online Help.



MORE INFORMATION
Works does not treat dates beyond June 3, 2079 as dates. For example, if you enter 6/4/2079 into a Database field or Spreadsheet cell, Works interprets that entry as a text string, rather than a numeric value.

Additional query words: 2.00 2.00a 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a w_works wrong future December 31

Keywords: kbprb KB128749

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.