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.

Date and time formats are not case-sensitive and so can be written in upper or lower case.

A separator must be used between individual date/time components:

You can use these separators for dates / -

You must use this separator for time :

 

A space must be used between the date and the time.

For example

dd/mm/yyyy hh:mm:ss

dd-mm-yyyy hh:mm:ss

 

 

The following combinations are supported:

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 enabled partial dates.

For example

dd/mm/yyyy

mm/dd/yyyy

yyyy-mm-dd

The following combinations are supported:

Hours Minutes Seconds

Hours Minutes

For example

hh:mm:ss

h:m:s

hh:mm

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