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

CalculationResult
dateformat(today())Wednesday 22nd September 2021
dateformat(today(), “l jS F Y”)Wednesday 22nd September 2021
dateformat(today(), “l F jS, Y”)Wednesday September 22nd, 2021
dateformat(today(), “M Y”)Sep 2021
dateformat(today(), “M-y”)Sep-21
dateformat(today(), “F jS, Y”)September 22nd, 2021
dateformat(today(), “d-m-y”)22-09-21
dateformat(today(), “Y-m-d”)2021-09-22

Get Started