The following table identifies the predefined date and time format names. These may be used by name as the style argument for the Format function:
| Format Name | Description |
|---|---|
| General Date, or G | Displays 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's LocaleID value. |
| Long Date, or D | Displays a date according to your locale's long date format. |
| Medium Date | Displays a date using the medium date format appropriate for the language version of the host application. |
| Short Date, or d | Displays a date using your locale's short date format. |
| Long Time, or T | Displays a time using your locale's long time format; includes hours, minutes, seconds. |
| Medium Time | Displays time in 12-hour format using hours and minutes and the AM/PM designator. |
| Short Time, or t | Displays a time using the 24-hour format, for example, 17:45. |
| f | Displays the long date and short time according to your locale's format. |
| F | Displays the long date and long time according to your locale's format. |
| g | Displays the short date and short time according to your locale's format. |
| M, m | Displays the month and the day of a date. |
| R, r | Formats the date and time as Greenwich Mean Time (GMT) |
| s | Formats the date and time as a sortable index. |
| u | Formats the date and time as a GMT sortable index. |
| U | Formats the date and time with the long date and long time as GMT. |
| y | Formats the date as the year and month. |
Format Function | Predefined Numeric Formats (Format Function) | User-Defined Date/Time Formats (Format Function)