FORMULA LANGUAGE


Time­date constants
A time-date constant consists of a time and/or a date enclosed in square brackets formatted as follows:
If time-date values are subtracted, the result is an integer that represents the difference between the times in seconds.

The table below shows the formats you can use to specify a date in a Notes field, assuming the operating system's default date format is US English and the year is 2002.

Tip Display Time must be selected in the Date/Time field properties box for the time to display. It is not selected by default.
Time-date formatConstantDate/Time field resultText field result
24-hour time[5:30]05:30 AM05:30:00 AM
12-hour time[5:30 PM]05:30 PM05:30:00 PM
24-hour time[17:30]05:30 PM05:30:00 PM
Date[6/15]06/15/200206/15/2002
Date[6/15/02]06/15/200206/15/2002
Time-date[6/15 5:30 PM]06/15/2002 05:30 PM06/15/2002 05:30:00 PM
Time-date[5:30 PM 6/15]06/15/2002 05:30 PM06/15/2002 05:30:00 PM
Difference[5:30 PM]-[5:30]43200.0043200