Custom date and time formats
The formats are assigned using tokens for day, month, year etc. (case sensitive, see below) with any delimiters. Time formats must be enclosed in square brackets. Examples:
| dd-MM-yyyy |
| d MMM - [H:mm:ss] |
If you want to include a word literally, enclose it in single quote marks, example:
| 'Copied:' yyyy-MM-dd, 'at' [H:mm] |
All tokens are case sensitive!
Date tokens
| token | | example |
| yy | 2 digit year | 02 |
| yyyy | 4 digit year | 2007 |
| M | 1 or 2 digit month | 1 |
| MM | 2 digit month | 01 |
| MMM | short month name | Jan |
| MMMM | full month name | January |
| d | 1 or 2 digit day | 1 |
| dd | 2 digit day | 01 |
| ddd | short day of week | Mon |
| dddd | full day of week | Monday |
Time tokens
| token | | example |
| h | 1 or 2 digit hour (12 hours) | 2 |
| hh | 2 digit hour (12 hours) | 02 |
| H | 1 or 2 digit hour (24 hours) | 2 |
| HH | 2 digit hour (24 hours) | 14 |
| m | 1 or 2 digit minutes | 5 |
| mm | 2 digit minutes | 05 |
| s | 1 or 2 digit seconds | 0 |
| ss | 2 digit seconds | 00 |
| t | A or P | A |
| tt | AM or PM | PM |
Note: AM/PM (or equivalent) will only show if they are activated in your Windows' Regional
Settings, Customize.. / Time.
|