Home > Appendices > Appendix E - Date and Time Format Codes
Download this articleAppendix E - Date and Time Format Codes
The following table lists the date and time format codes that you can use when customizing a date format and a time format.
| Code | Description | Displayed Value |
|---|---|---|
| M | Month | 1 to 12 |
| MM | Month | 01 to 12 |
| MMM | Month | Jan to Dec |
| MMMM | Month | January to December |
| dd | Date | 01 to 31 |
| d | Date | 1 to 31 |
| ddd | Date | Sun to Sat |
| dddd | Date | Sunday to Saturday |
| yyyy | Year | 2021 |
| yy | Year | 21 |
| TT | Time | AM or PM |
| tt | Time | a.m. or p.m. |
| HH | Hour | 00 to 23 |
| H | Hour | 0 to 23 |
| hh | hour | 00 to 12 |
| h | Hour | 0 to 12 |
| m | Minute | 0 to 59 |
| mm | Minute | 00 to 59 |
| s | Second | 1 to 59 |
| ss | Second | 01 to 59 |
On this page