Pre-defined Date and Time formats for the FORMAT Function
The following table identifies the predefined date and time format names. If you use strings other than these predefined strings, they will be interpreted as a custom date and time format.
Format specification |
Description |
|---|---|
"General Date" |
Displays a date and/or time. For example, 3/12/2008 11:07:31 AM. Date display is determined by your application's current culture value. |
"Long Date" or "Medium Date" |
Displays a date according to your current culture's long date format. For example, Wednesday, March 12, 2008. |
"Short Date" |
Displays a date using your current culture's short date format. For example, 3/12/2008. |
"Long Time" or "Medium Time" |
Displays a time using your current culture's long time format; typically includes hours, minutes, seconds. For example, 11:07:31 AM. |
"Short Time" |
Displays a time using your current culture's short time format. For example, 11:07 AM. |
Remarks
The formatting strings are based on Visual Basic (OLE Automation) and not the .NET Framework formatting strings; therefore, your results might be slightly different than what you expect from .NET format strings. Note that abbreviations such as âDâ for Long Date and âtâ for Short Time are not supported.
Important
If value is BLANK() the function returns an empty string.
If format_string is BLANK(), the value is formatted with a "General Date" format.