Code |
Date Format |
---|---|
D |
Days as 1-31 |
DD |
Days as 01-31 |
DY |
Week days as 1-7 |
DAY |
Week 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 |
DATE |
DD/MM/YYYY For example, 31/01/2001 |
SHORT_DATE |
D/M/Y For example, 31/1/1 |
LONG_DATE |
Long date format For example, Wed Jan 31 2001 |
XML_DATE |
YYYY-MM-DD For example, 2001-01-31 |
LOCALE_DATE |
Local date format For example, Jan 31, 2001 |
Note
Any character codes other than the date format codes listed in this table are embedded as is.
To insert codes reserved as date format codes, you can use HTML code (for example, you might useD for D).