-
The custom date format field is displayed.
-
Type a date format or click Show/Hide Date Format Tools to select components from the date format tools drop-down.
Note:At least two characters must be entered for any <Custom> format. Custom date formats use standard date and time strings. For more information, see Custom Date and Time Format Strings on the Microsoft MSDN site.
- Click a format component to insert the corresponding formatting in the custom date format field or expand additional options, if available.
Date Formats
Description
Day of Month
Select to expand the following:
-
Day of Month (1-31)- Inserts d
-
Day of Month (01-31)- Inserts dd
Day of Week
Select to expand the following:
-
Day of Week- Inserts dddd
-
Abbreviated Day of Week- Inserts ddd
Year
Select to expand the following:
-
Two Digit Year- Inserts yy
-
Four Digit Year- Inserts yyyy
Month
Select to expand the following:
-
Month (1-12)- Inserts M
-
Month (01-12)- Inserts MM
Month Name
Select to expand the following:
-
Month Name- Inserts MMMM
-
Abbreviated Month Name- Inserts MMM
Date Separator
Inserts /
Time Formats
Description
Hour (12)
Select to expand the following:
-
Hour (1-12)- Inserts h
-
Hour (01-12)- Inserts hh
Hour (24)
Select to expand the following:
-
Hour (0-23)- Inserts H
-
Hour (00-23)- Inserts HH
AM/PM
Inserts tt
Minutes
Inserts mm
Seconds
Inserts ss
Time Separator
Inserts :
Tip:When the cursor is placed in the custom date format field, a preview of the custom date format is populated on the blue bar below the field.
Note:Spaces and characters that are not used as format specifiers can be inserted between format components. This excludes the characters inserted by the date format tools components, as well as f, F, g, K, z, and %. Any character can be inserted when it is enclosed in a pair of ' or ". For example, 'M' or "M". For more information, see Custom Date and Time Format Strings on the Microsoft MSDN site.