Page tree
Skip to end of metadata
Go to start of metadata

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:

CategoryFormatterExample
Weekdayd0..6
ddSu
dddSun
ddddSunday
YearYY17
YYYY2017
MonthM1..12
Mo1st..12th
MM01..12
MMMJan
MMMMJanuary
QuarterQ1..4
Qo1st..4th
DayD1..31
Do1st..31st
DD01..31
Day of yearDDD1..365
DDDo1st..365th
DDDD001..365
Week of yearw1..53
wo1st..53rd
ww01..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

  • No labels