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 | |
| Character | Meaning | Example |
|---|---|---|
| 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 (24 hour clock) | |
| m | Minute | |
| s | Second |
Any characters which are not letters will remain the same in the formatted date.