When using the dateformat Function in a Calculation,
you can use any of the following to format the date exactly as you would like it displayed.
The default, if no format is specified, is “l jS F Y” – see examples below.
| Character | Description | Example returned values |
|---|
| DAY | | |
| d |
Day of the month, 2 digits with leading zeros |
01 to 31 |
| D |
A textual representation of a day, three letters |
Mon through Sun |
| j |
Day of the month without leading zeros |
1 to 31 |
| l (lowercase ‘L’) |
A full textual representation of the day of the week |
Sunday through Saturday |
| S |
English ordinal suffix for the day of the month, 2 characters |
st, nd, rd or
th. Works well with j
|
| WEEK |
|
|
| W |
ISO-8601 week number of year, weeks starting on Monday |
Example: 42 (the 42nd week in the year) |
| MONTH |
|
|
| F |
A full textual representation of a month, such as January or March |
January through December |
| m |
Numeric representation of a month, with leading zeros |
01 through 12 |
| M |
A short textual representation of a month, three letters |
Jan through Dec |
| n |
Numeric representation of a month, without leading zeros |
1 through 12 |
| YEAR |
|
|
| Y |
A full numeric representation of a year, 4 digits |
Examples: 1999 or 2003 |
| y |
A two digit representation of a year |
Examples: 99 or 03 |
Examples
| Calculation | Result |
|---|
| dateformat(today()) | Saturday 27th July 2024 |
| dateformat(today(), “l jS F Y”) | Saturday 27th July 2024 |
| dateformat(today(), “l F jS, Y”) | Saturday July 27th, 2024 |
| dateformat(today(), “M Y”) | Jul 2024 |
| dateformat(today(), “M-y”) | Jul-24 |
| dateformat(today(), “F jS, Y”) | July 27th, 2024 |
| dateformat(today(), “d-m-y”) | 27-07-24 |
| dateformat(today(), “Y-m-d”) | 2024-07-27 |