Cannot Use Field Name with Time/Date Format (77281)

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 "9:00" or "9/13/91". 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): "Microsoft Works for Windows User's Guide," version 2.0,
              page 264.