Knowledge Base

Works: Database and Spreadsheet Sample Date Incorrect

Article ID: 128749

Article Last Modified on 11/15/2004

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