Date/Time format rules



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

Category

Format

Example

Category

Format

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





 Time format specifications

Category

Format

Example

Category

Format

Example

AM/PM

A

AM PM

a

am pm

Hour





H

0 1 ... 22 23

HH

00 01 ... 22 23

h

1 2 ... 11 12

hh

01 02 ... 11 12

k

1 2 ... 23 24

kk

01 02 ... 23 24

Minute

m

0 1 ... 58 59

mm

00 01 ... 58 59

Second

s

0 1 ... 58 59

ss

00 01 ... 58 59



Predefined date and time presets based on locale

Format preset

Example (en locale)

Example (de 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/21/1985

21.08.1985

l

8/21/1985

21.8.1985

LL

August 21

1985

21. August 1985

ll

Aug 21

1985

21. Aug. 1985