Code |
Date/Time Part |
---|---|
D |
Days as 1-31 |
DD |
Days as 01-31 |
DAY |
Days as Sun-Sat |
M |
Months as 1-12 |
MM |
Months as 01-12 |
MON |
Months as Jan-Dec |
Y |
Years as 0-99 |
YY |
Years as 00-99 |
YYYY |
Years as 1900-9999 |
MS |
Milliseconds as 000-999 |
SS |
Seconds as 00-59 |
NN |
Minutes as 00-59 |
H |
Hours as 0-23 |
HH |
Hours as 00-23 |
H12 |
Hours as 0-12 |
HH12 |
Hours as 00-12 |
AM|PM |
Meridian indicator |
Note
Any character codes other than the date-part codes listed in this table are embedded as is.
To insert codes reserved as date-part codes, you can use HTML code (for example, you might use D for D).