• 12-hour time -- A time in the format [hh:mm:ss] followed by the letters AM or PM. The hours can range from 00 to 12. The seconds are optional and default to 00.
• 24-hour time -- A time in the format [hh:mm:ss]. The hours can range from 00 to 23. The seconds are optional and default to 00.
• Date -- A date in the operating system's default date format. Some examples include:

  Region	Default date format	Entering "[01/02/03]" results in
  United States	'[mm/dd/yyyy]	January 2, 2003
  France	'[dd/mm/yyyy]	February 1, 2003
  Japan	'[yyyy/mm/dd]	February 3, 2001

  The year (yyyy) is optional and defaults to the current year. If you use yy to specify a year, in the 20th century, yy is 50 or greater and in the 21st century, yy is less than 50. The validity of a date format depends on the date separator that users choose in their operating system control panel. The default separator for Windows, UNIX, and Macintosh is a slash (/). The default separator for OS/2 is a hyphen (­).
• Time and date -- A time and a date in the format [time date] or [date time].

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.

To specify a time zone in a Time zone field, you can select a zone from a drop-down list of options or use the functions @TimeZoneToText and @TextToTimeInZone to manipulate the formats in which time values display programmatically.

Notes converts and saves human-readable time zone values using the following time zone attributes:

Z=5$DO=1$DL=4 1 1 10 -1 1$ZX=25$ZN=Eastern

This indicates that the time zone is 5 hours before Greenwich Mean Time (-5). DST is in effect and starts in the month of April(4), during week 1, on day 1 of the week, which is a Sunday, and ends in October(10), during the last week (-1), also on a Sunday(1). The ZX and ZN attributes are values used exclusively by Notes.

If you use a Time zone field as the default value for a view column, it displays as a similar string of attribute and value pairs. Use @TimeZoneToText to convert the field to a human-readable format.

You can enter these attribute and value pairs as the default value for a Time zone field, or you can let the @TimeToTextInZone function do the work for you. For example, to display a box specifying the current time in Alaska, you could create a Hotspot button with this formula:

@Prompt([Ok];"Current time in Alaska";@TimeToTextInZone(@Now;"Z=9$DO=1$DL=4 1 1 10 -1 1"))

@Prompt([Ok];"Current time there";@TimeToTextInZone(@Now;zone))

@Time
@TimeMerge
@TextToTime
@Today
@Tomorrow
@ToTime
@Now

Glossary