meta data for this page
Data Analyzer : Date formats
When you use a date object in the Data Analyzer, the string dimension object needs to be formatted as YYYY-MM-DD in Webi (ex. 2024-12-21). Then in the Data Analyzer you can set a specific format to display the date.
Date formats
| Input | Example | Description |
|---|---|---|
| d | 2 or 18 | Day of the month. It is represented as a one- or two-digit number. |
| dd | 02 or 18 | Day of the month. It is represented as a two-digit number. |
| ddd | Wed | Day of the week. It is represented as a three-letter abbreviation of the day of the week. |
| dddd | Wednesday | Day of the week. It is represented as the full name of the day of the week. |
| M | 3 or 11 | Month. It is represented as a one- or two-digit number. |
| MM | 03 or 11 | Month. It is represented as a two-digit number. |
| MMM | Mar | Month. It is represented as a three-letter abbreviation of the name of the month. |
| MMMM | March | Month. It is represented as the full name of the month. |
| yy | 24 | Year. It is represented as a two-digit number. |
| yyyy | 2024 | Year. It is represented as a four-digit number. |
| h | 1 or 12 | Hour of the day using the 12-hour format [1 – 12]. It is represented as a one or two-digit number. |
| hh | 01 or 12 | Hour of the day using the 12-hour format [1 – 12]. It is represented as a two-digit number. |
| H | 0 or 23 | Hour of the day using the 24-hour format [0 – 23]. It is represented as a one or two-digit number. |
| HH | 00 or 23 | Hour of the day using the 24-hour format [0 – 23]. It is represented as a two-digit number. |
| k | 1 or 24 | Hour of the day using the 24-hour format [1 – 24]. It is represented as a one or two-digit number. |
| kk | 01 or 24 | Hour of the day using the 24-hour format [1 – 24]. It is represented as a two-digit number. |
| m | 0 or 59 | Minutes [0 – 59]. It is represented as a one or two-digit number. |
| mm | 00 or 59 | Minutes [0 – 59]. It is represented as a two-digit number. |
| s | 0 or 59 | Seconds [0 – 59]. It is represented as a one or two-digit number. |
| ss | 00 or 59 | Seconds [0 – 59]. It is represented as a two-digit number. |
| t | a or p | am/pm – a one-letter indicator. |
| tt | am or pm | am/pm – a two-letter indicator. |
| T | A or P | AM/PM – a one-letter indicator. |
| TT | AM or PM | AM/PM – a two-letter indicator. |
| UTC: | UTC:dd/MM/yyyy | Indicates that the UTC time zone should be used. |
| GMT+-N: | GMT+6:dd/MM/yyyy | Indicates the time zone to use, where N can be changed from 1 to 12. |
| Pattern | Example of a formatted date |
|---|---|
| yyyy-MM-dd | 2021-05-25 |
| M/d/yy | 4/25/21 |
| MMM d, yyyy | Mar 25, 2021 |
| MMMM d, yyyy | March 25, 2021 |
| dddd, MMMM d, yyyy | Sunday, March 25, 2021 |