Microsoft KB Archive/77281

= Cannot Use Field Name with Time/Date Format =

Article ID: 77281

Article Last Modified on 7/30/2001



This article was previously published under Q77281



SUMMARY
Any field name using the Time/Date format cannot be used in a Works for Windows version 2.0 formula. This includes a field name such as &quot;9:00&quot; or &quot;9/13/91&quot;. If used in a formula, these field names will return the value of a serial number used by Works to calculate the Time/Date values.



MORE INFORMATION
The field name must start with a letter, have a space before the colon, or have a letter in front of the colon for Works to recognize it as a valid field name in a formula.

The following are some examples of field names and the values returned if entered in a Works formula: Field Name    Value       Formula          Returns --    ---              -

Field1        1           =Field1          1 9:00          1           ='9:00:00'       0.375 9 : 00         1           ='9 : 00'        1 AM 9:00        1           ='AM 9:00'       1 Date 9/13/91  1           ='Date 9/13/90'  1 9/13/90       1           ='9/13/90'       33129

Reference(s): &quot;Microsoft Works for Windows User's Guide,&quot; version 2.0, page 264.

Additional query words: 2.00 \* kbsweep w_works

Keywords: KB77281

-

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

© Microsoft Corporation. All rights reserved.