Constructing date formats

The following date format options are available, from which you can build your definitions.

Creating date and time formats

Days

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).

Months

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.

Years

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: