Date Format Properties
| Date Format | Description |
|---|---|
| Full date format | Date represented by the day of the week, month, date and year. Default is EEEE, MMMM D, YYYY. Maximum number of characters: 255. |
| Long date format | Date represented by month, date and year. Default is MMMM D, YYYY. Maximum number of characters: 255. |
| Medium date format | Date represented by date, month and/or year. Default is D-MMM-YYYY. Maximum number of characters: 255. In the case of regions that do not use commas, periods or slashes with dates, an additional format is included that is specific to the region. When no date format is selected, the medium format is the default format used by the application. |
| Short date format | Date represented by date, month and/or year. Default is DD/MM/YY. Short date formats are used for lists and calendars. Numeric values only. |
| Shortest date format | Date represented by date and month. Default is DMMM. Shortest date format are used in candidate files and other lists that include many columns. |
| Date Format Details | Description |
|---|---|
| Text | A date element that always appears in the form of text, such as days of the week, will be displayed in long form if four letters are used for its representation. If less than four letters are used, the date element will appear in an abbreviated form. For example, configuring a date format using "EEE" would produce "Fri" for Friday, while using "EEEE" would produce the long form "Friday". |
| Numbers | The system adds zeros to single numbers in certain cases. For example, if the date element "DD" is part of the date format, the ninth day of the month will be displayed with a leading zero, thus, "09". If the date element is "D", however, the system will display "9" without a leading zero. |
| Text and Numbers | When the date format element is composed of one or two characters, a numeric value results. For example, if the date format element is "M" or "MM", the month of February will be depicted as "2" and "02" respectively. On the other hand, a date format element made up of three or more characters will result in a textual representation of the date: in the case of "MMM", February will appear as "FEB", if "MMMM" is used, February will be displayed as "February". |
| Date Format Syntax | Meaning | Presentation | Example (US locale) |
|---|---|---|---|
| Y | Year | Numeric | 2009 |
| M | Month of the year | Alphanumeric | July, Jul. or 07 |
| D | Day of the month | Numeric | 10 |
| H | Hour AM/PM (1-12) | Numeric | 12 |
| h | Hour of the day (0-23) | Numeric | 22 |
| m | Minute of the hour | Numeric | 38 |
| s | Seconds | Numeric | 59 |
| E | Day of the week | Textual | Tue, Tuesday |
| a | AM/PM marker | Textual | PM |
| K | Hour in AM/PM (0-11) | Numeric | 0 |
| ‘ | Escape for text | Delimiter | ‘ |
| ‘‘ | Single quotation mark (twice the escape character) | Literal |