Format Function Named Date/Time Formats

Description

The following table identifies the predefined date and time format names

Format Name

Description

General Date

Display a date and/or time. For real numbers, display a date and time, for example, 4/3/93 05:34 PM. If there is no fractional part, display only a date, for example, 4/3/93. If there is no integer part, display time only, for example, 05:34 PM. Date display is determined by your system settings.

Long Date

Display a date according to your system's long date format.


(continued)

Medium Date

Display a date using the medium date format appropriate for the language version of the host application.

Short Date

Display a date using your system's short date format.

Long Time

Display a time using your system's long time format; includes hours, minutes, seconds.

Medium Time

Display time in 12-hour format using hours and minutes and the AM/PM designator.

Short Time

Display a time using the 24-hour format, for example, 17:45.


See Also

Format function, Format function named numeric formats, Format function user-defined date/time formats.