A date time format is a format for displaying Date or DateTime components in grids and forms. A default format can be set in System Configuration and in each application. Individual components can have a date time format set in stream view attribute for grids or layout component for forms.
| 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 can be used to provide locale specific date formats. If a date style mapping is specified, the date format from the mapping will be used instead of the date time format string, for users with a locale that uses that date style. | |
| Date Format | The format for the Date or Date Time, using the patterns below. |
| Date Style Name | The Date Style this format should be applied for. |
| Character | Meaning | Example (2 August 2018, 16:09:22) |
|---|---|---|
| E | Day of week as number (1-7 where Monday=1) | 4 |
| EEEE | Day of week, full name | Thursday |
| d | Day of month | 2 |
| dd | Day of month, with leading 0 if less than 10 | 02 |
| M | Month as a number | 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 (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.