Date Formats

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.

CharacterDescriptionExample returned values
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
W ISO-8601 week number of year, weeks starting on Monday Example: 42 (the 42nd week in the year)
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
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


dateformat(today())Monday 4th July 2022
dateformat(today(), “l jS F Y”)Monday 4th July 2022
dateformat(today(), “l F jS, Y”)Monday July 4th, 2022
dateformat(today(), “M Y”)Jul 2022
dateformat(today(), “M-y”)Jul-22
dateformat(today(), “F jS, Y”)July 4th, 2022
dateformat(today(), “d-m-y”)04-07-22
dateformat(today(), “Y-m-d”)2022-07-04

Get Started