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

This page includes details about Date format options, available in Date, Time and DateTime columns.

You can use any of the available types to specify a format of the date displayed in Date, Time and DateTime column type.

Default date format is L. Default time format is hh:mm A

There are some predefined format presets based on locale available.

 Date format specifications

CategoryFormatExample
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



 Time format specifications

CategoryFormatExample
AM/PMAAM PM
aam pm
Hour




H0 1 ... 22 23
HH00 01 ... 22 23
h1 2 ... 11 12
hh01 02 ... 11 12
k1 2 ... 23 24
kk01 02 ... 23 24
Minutem0 1 ... 58 59
mm00 01 ... 58 59
Seconds0 1 ... 58 59
ss00 01 ... 58 59

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

  • No labels