This page includes details about Date format options, available in Date and DateTime columns.
You can use any of the available types to specify a format of the date displayed in Date and DateTime column type.
By default used format L
There are some predefined format presets based on locale available. And date format specification is following:
| Category | Formatter | Example |
|---|---|---|
| Weekday | d | 0..6 |
| dd | Su | |
| ddd | Sun | |
| dddd | Sunday | |
| Year | YY | 17 |
| YYYY | 2017 | |
| Month | M | 1..12 |
| Mo | 1st..12th | |
| MM | 01..12 | |
| MMM | Jan | |
| MMMM | January | |
| Quarter | Q | 1..4 |
| Qo | 1st..4th | |
| Day | D | 1..31 |
| Do | 1st..31st | |
| DD | 01..31 | |
| Day of year | DDD | 1..365 |
| DDDo | 1st..365th | |
| DDDD | 001..365 | |
| Week of year | w | 1..53 |
| wo | 1st..53rd | |
| ww | 01..53 |
Predefined date and time presets based on locale
Format preset | Example (en locale) | Example (de locale) |
|---|---|---|
LT | 8:30 PM | 20:30 |
LTS | 8:30:25 PM | 20:30:25 |
L | 08/02/1985 | 02.08.1985 |
l | 8/02/1985 | 02.8.1985 |
LL | August 2 1985 | 2. August 1985 |
ll | Aug 2 1985 | 2. Aug. 1985 |
LLL | August 2 1985 08:30 PM | 2. August 1985 20:30 |
| lll | Aug 2 1985 08:30 PM | 2. Aug. 1985 20:30 |
LLLL | Thursday, August 2 1985 08:30 PM | Donnerstag, 2. August 1985 20:30 |
| llll | Thu, Aug 2 1985 08:30 PM | Do., 2. Aug. 1985 20:30 |