Microsoft KB Archive/112429

= Works: Converting a Five- or Six-Digit Number to a Date =

Article ID: 112429

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * 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 Q112429



SUMMARY
Some database applications may require you to enter date values as a 5- or 6-digit number (that is, 5/15/92 is entered as 051592). To convert this value to a date in Works, enter the following formula in a separate field

=DATE(MOD(ref,100),INT(ref/10000),MOD(INT(ref/100),100))

where "ref" is replaced with a field name in the database or a cell reference in the spreadsheet.

This equation places the decimal equivalent of the date in the destination field. Note that if the day or year number has a single digit, as in 5/5/92, the original date value would have to include a zero, as in 050592.

To change the field to a date format in Works 3.0, 4.0, 4.5 and 4.5a:


 * 1) From the Format menu, click Number.
 * 2) Select Date from the Format box.
 * 3) Select the desired date format in the Date box and click OK or press ENTER.

To change the field to a date format in Works 2.0:


 * 1) From the Format menu, click Time/Date.
 * 2) Select the desired date format in the Show and Date boxes and click OK or press ENTER.

Additional query words: w_works kbhowto db interop conversion 2.00 2.00a 3.00 4.00 4.00a 4.50 4.50a

Keywords: kbinfo KB112429

-

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

© Microsoft Corporation. All rights reserved.