...
| Field | Description |
|---|
| Basic Settings |
| Name | The name of the Date Time Format |
| Date Time Format String | A string describing the format for the Date or DateTime e.g. dd/MM/yyyy or dd-MM-yy HH:mm:ss. For details of possible patterns see below. |
| Date Style Mappings |
| Date Style Mappings | Character | Meaning | Example (2 August 2018, 16:09:22) |
|---|
| d | Day of month |
, without leading 0 | 2 |
| dd | Day of month, with leading 0 if less than 10 | 02 |
| M | Month as a number |
, without leading 0 | 8 |
| MM | Month as a number, with leading 0 if less than 10 | 08 |
| MMM | Month as text, abbreviated to 3 characters | Aug |
| MMMM | Month as text, full name | August |
| y or yyyy | Year, 4 digits | 2018 |
| yy | Year, 2 digits | 18 |
| H | Hour of day (0-23) | 16 |
| HH | Hour of day (0-23), with leading 0 if less than 10 | 16 |
| h | Clock hour of half day ( |
24 hour clock)m | Minute | s | Second| 1-12) | 4 |
| hh | Clock hour of half day (1-12), with leading 0 if less than 10 | 04 |
| m | Minute | 9 |
| mm | Minute, with leading 0 if less than 10 | 09 |
| s | Second | 22 |
| ss | Seconds, with leading 0 if less than 10 | 22 |
Any characters which are not letters will remain the same in the formatted date.