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. |
|
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). |
Format Function, Format Function — Named Numeric Formats.