Microsoft KB Archive/76999

= Works: Acceptable Date Formats in Spreadsheets and Databases =

Article ID: 76999

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * 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 Q76999



SUMMARY
You can type a date in any format in a Works for Windows database or spreadsheet if you don't plan to use formulas with the dates or if you don't plan to sort them. However, if you want to use the dates in formulas or to perform a sort based on them (that is, earliest dates first), you must type the dates in a format Works recognizes.

To use a format that Works recognizes, enter the date in one of the pre-defined date formats such as &quot;mm/dd/yy&quot;. For example, enter the date October 30, 1991 by typing 10/30/91 in the database date field or spreadsheet date cell.

If you enter the date in a format that is not pre-defined, such as &quot;mm-dd-yy&quot; (using hyphens instead of forward slashes), Works will not recognize the entry as a date because it is not a pre-defined format.



MORE INFORMATION
The following is a list of the Works pre-defined date formats. If you enter a date in any of these formats, Works can perform calculations and sort chronologically in the database or spreadsheet.

NOTE: The year can be entered in abbreviated form (for example, 10/30/91) in all of the above examples and the program will still work correctly.

Works stores a date as a serial date, which is an integer value assigned to a date. Works assigns the value 1 to January 1, 1900, the value 2 to January 2, 1900, and so on. Many spreadsheet programs use this algorithm so they can perform arithmetic calculations with dates. The valid date range in Works is 1/1/1900 to 6/3/2079.

Additional query words: w_works 2.00 2.00a 3.00 4.00 4.00a 4.50 4.50a ss db date serial number

Keywords: kbinfo KB76999

-

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

© Microsoft Corporation. All rights reserved.