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())Tuesday 25th January 2022
dateformat(today(), “l jS F Y”)Tuesday 25th January 2022
dateformat(today(), “l F jS, Y”)Tuesday January 25th, 2022
dateformat(today(), “M Y”)Jan 2022
dateformat(today(), “M-y”)Jan-22
dateformat(today(), “F jS, Y”)January 25th, 2022
dateformat(today(), “d-m-y”)25-01-22
dateformat(today(), “Y-m-d”)2022-01-25

Get Started