This page includes details about Date format options, available in Date and DateTime columns.
You can use any of available types to specify a format of date displayed in Date and DateTime column type.
By default used format L
There are some predefined format presents 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 |