Date / Time functions

Date variables are stored as IEEE 64-bit (8-byte) floating-point numbers that represent dates ranging from 1 January 100 to 31 December 9999 and times from 0:00:00 to 23:59:59. Any recognizable literal date values can be assigned to Date variables. Date literals must be enclosed within number signs (#).

Sample of date literals:
#January 1, 1993#
#1 Jan 93#
# 8/23/1970 3:45:39AM #

# 8/23/1970 #
# 3:45:39AM #

# 3:45:39 #

# 13:45:39 #

# 1AM #

Date variables display dates according to the short date format recognized by your computer. Times display according to the time format (either 12-hour or 24-hour) recognized by your computer.

Remark

Support of date variables and related functions have been added in version 4.37