Learn about date formats in templates
Format codes
Select the required date format from the list below.
|
Date format code |
Date component |
Example |
|---|---|---|
|
d |
day of month (without leading zero) |
3 |
|
dd |
day of month (with leading zero) |
03 |
|
ddd |
day of week (three letters) |
Tue |
|
dddd |
day of week (full) |
Tuesday |
|
M |
month (numeric, without leading zero) |
1 |
|
MM |
month (numeric, with leading zero) |
01 |
|
MMM |
month (three letters) |
Jan |
|
MMMM |
month (full) |
January |
|
yy |
year (two digits) |
12 |
|
yyyy |
year (four digits) |
2012 |
|
th |
day of the month suffix |
st, nd, rd, or th |
Examples for the date 1 September 2024
You can use other symbol for additional format. Commonly used symbols for separating date components are / (forward slash) and - (hyphen). The examples below show some common formatting options.
|
Format code |
Report Output |
|
dd/MM/yy |
01/09/24 |
|
ddd, dd-MMM-yyyy |
Sun, 01-Sep-2024 |
|
dddd, dth MMMM yyyy |
Sunday, 1st September 2024 |