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 | ||||||
|---|---|---|---|---|---|---|---|
| Parent Details | |||||||
| Container | The Container (Application or Package) containing this Date Time Format. Container is a drop down field listing all Containers for this instance which the user has permission to view. | ||||||
| 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 belowsee Date and Time Format Patterns. | ||||||
| |||||||
| Date Style Mappings can be used to provide locale 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 belowusing Date and Time Format Patterns. | ||||||
| Date Style Name | The Date Style Mapping 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 | |||||
...
| . |