Date/time question formats

All components except years may be expressed as a single or double letter. A single letter means the value will be shown as a single digit if less than 10, or two digits if 10 or greater. A double letter means that the value will always be shown as two digits, with a leading zero as necessary. Years must always be expressed as four letters:

second	s or ss
minute	m or mm
hour	h or hh
day	d or dd
month	m or mm
year	yyyy

A single letter means the value will be shown as a single digit if less than 10, or two digits if 10 or greater. A double letter means that the value will always be shown as two digits, with a leading zero as necessary.

Months and minutes are both expressed as m and are distinguished by context.

A separator must be used between individual date/time components. Valid separators are:

/  -  .  :  space

The following combinations are allowed:

Day Month Year

Month Day Year

Year Month Day

It is not possible to have a date format using just the month and the year unless you have partial dates enabled.

For example

dd/mm/yyyy

d:m yyyy

mm.dd.yyyy

m/d/yyyy

yyyy-m-d

yyyy/mm/dd

The following combinations are allowed:

Hours Minutes Seconds

Hours Minutes

For example

hh:mm:ss

h/m/s

hh/mm

h-m

A datetime format is a date format followed by a separator and a time format.

For example

d.m.yyyy hh:mm:ss

yyyy/mm/dd hh-mm