Date Format Guide for Settings
/docs/Setup/date-format
For use on the Local Settings tab within the Settings Page.
This guide explains the available date formatting keys and what they output. You can combine these keys to create your desired date format.
l, jS F Y
Output:
Monday, 3rd March 2025
Day
| Key | Description | Example Output |
|---|---|---|
d |
Day of the month, 2 digits with leading zeros | 01 - 31 |
D |
A textual representation of a day, three letters | Mon - Sun |
j |
Day of the month without leading zeros | 1 - 31 |
l |
Full textual representation of the day of the week (lowercase L) | Sunday - Saturday |
N |
ISO 8601 numeric representation of the day of the week | 1 (Mon) - 7 (Sun) |
S |
English ordinal suffix for the day of the month | st, nd, rd, th |
w |
Numeric representation of the day of the week | 0 (Sun) - 6 (Sat) |
z |
Day of the year (starting from 0) | 0 - 365 |
Example format:
l jS
Output:
Monday 3rd
Week
| Key | Description | Example Output |
|---|---|---|
W |
ISO 8601 week number of year | 01 - 53 |
Example format:
Week W
Output:
Week 42
Month
| Key | Description | Example Output |
|---|---|---|
F |
Full textual month | January - December |
m |
Numeric month with leading zero | 01 - 12 |
M |
Short textual month | Jan - Dec |
n |
Numeric month without leading zero | 1 - 12 |
t |
Number of days in the month | 28 - 31 |
Example format:
j F Y
Output:
3 March 2025
Year
| Key | Description | Example Output |
|---|---|---|
L |
Whether it is a leap year | 1 or 0 |
o |
ISO 8601 week-numbering year | 1999, 2003 |
X |
Expanded full numeric year | +1999, +10191 |
x |
Expanded full numeric representation if required | 1999, +10191 |
Y |
Full numeric year | 2025 |
y |
Two digit year | 25 |
Example format:
j F Y
Output:
3 March 2025
Time
| Key | Description | Example Output |
|---|---|---|
a |
Lowercase am/pm | am, pm |
A |
Uppercase AM/PM | AM, PM |
g |
12-hour format without leading zero | 1 - 12 |
G |
24-hour format without leading zero | 0 - 23 |
h |
12-hour format with leading zero | 01 - 12 |
H |
24-hour format with leading zero | 00 - 23 |
i |
Minutes with leading zero | 00 - 59 |
s |
Seconds with leading zero | 00 - 59 |
u |
Microseconds | 654321 |
v |
Milliseconds | 654 |
Example format:
H:i:s
Output:
14:35:08
Timezone
| Key | Description | Example Output |
|---|---|---|
e |
Timezone identifier | UTC, GMT, Europe/London |
I |
Daylight saving time indicator | 1 or 0 |
O |
GMT offset without colon | +0200 |
P |
GMT offset with colon | +02:00 |
p |
Same as P, but returns Z for UTC |
Z |
T |
Timezone abbreviation | GMT, BST |
Z |
Timezone offset in seconds | -43200 - 50400 |
Example format:
H:i T
Output:
14:35 GMT
Full Date / Time
| Key | Description | Example Output |
|---|---|---|
c |
ISO 8601 formatted date | 2025-03-06T14:35:08+00:00 |
r |
RFC 2822 formatted date | Thu, 21 Dec 2000 16:01:07 +0200 |
U |
Seconds since Unix Epoch | 1709730000 |
Example format:
c
Output:
2025-03-06T14:35:08+00:00
Hijri Date Format Keys
These keys are used when formatting Hijri dates.
| Key | Description | Example Output |
|---|---|---|
l |
Day in words in full in the selected language | Monday |
d |
Hijri date without leading zero | 3 |
D |
Hijri date with leading zero | 03 |
a |
Hijri date in Arabic numbers without leading zero | ٣ |
S |
Ordinal suffix | st, nd, rd, th |
m |
Month number with leading zero | 09 |
M |
Month number without leading zero | 9 |
F |
Month name in full | Ramadan |
s |
Month number in Arabic | ٩ |
Y |
Full Hijri year | 1447 |
y |
Short Hijri year | 47 |
A |
Full Hijri year in Arabic numerals | ١٤٤٧ |
Example format:
l d F Y
Output:
Monday 3 Ramadan 1447
Arabic example format:
a s A
Output:
٣ ٩ ١٤٤٧
Common Format Examples
Standard UK Format
j F Y
Output:
3 March 2025
Short Format
d/m/Y
Output:
03/03/2025
Full Format with Time
l jS F Y H:i
Output:
Monday 3rd March 2025 14:35
Hijri Example
l d F Y
Output:
Monday 3 Ramadan 1447