The following date format options are available, from which you can build your definitions.
Creating date and time formats
Use d
to represent days of the month:
d
days appear as a number with no leading zero;
dd
days appear as a number with leading zero if relevant;
ddd
produces a number with appropriate suffix (e.g. 1st, 2nd).
Use m
or M
to represent months in dates:
m
month appears as a number with no leading zero;
mm
month appears as number with leading zero if relevant;
Mmm
month appears as three letter abbreviation;
Mmmm
month appears as the full month name.
Use the following to express years:
yy
last two digits of year;
yyyy
four digits.
Some formats are predefined in the Date formats pop-up menu: