Works: Database and Spreadsheet Sample Date Incorrect (128749)
The information in this article applies to:
- Microsoft Works 2.0
- Microsoft Works 2.0a
- Microsoft Works 3.0
- Microsoft Works 3.0a
- Microsoft Works 3.0b
- Microsoft Works 4.5
- Microsoft Works 4.5a
- Microsoft Works for Windows 95, version 4.0
- Microsoft Works for Windows 95, version 4.0 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.
| Modification Type: | Major | Last Reviewed: | 11/15/2004 |
|---|
| Keywords: | kbprb KB128749 |
|---|
|