formatDate
Description
Converts a date into a specific desired format, such as changing the display of a date from one representation to another.
Input / Parameter
date
The date to be formatted.
String/Text
(Current-Date)
-
Yes
format
The format to apply to the date. See 'Date Format' after this table, take note that you can combine the available format. e.g. Y-m-d, m/d/Y.
String/Text
-
see below
Yes
Date formats
q
Total Days
d
Day of month with leading 0. 01..31
j
Day of month. 1..31
l
Full day name. Monday..Sunday
D
Shortened day name. Mon..Sun
W
ISO-8601 week number.
w
Day of week. 0..6
N
ISO-8601 day of week. 1..7
z
Day of year. 0..365
S
Ordinal suffix for day of month. st, nd, rd, th
F
Full month name. January..December
M
Shorthand month name. Jan..Dec
m
Month with leading 0. 01..12
n
Month. 1..12
t
Days in month. 28..31
o
ISO-8601 year.
Y
Full year.
Time formats
y
Last two digits of the year. 00...99
L
Is leap year. 0, 1
a
Morning or afteroon lowercase. am, pm
A
Morning or afteroon uppercase. AM, PM
B
Swatch Internet time. 000..999
g
12-Hours. 1..12
G
24-Hours. 0..23
h
12-Hours with leading 0. 01..12
H
24-Hours with leading 0. 00..23
i
Minutes with leading 0. 00..59
s
Seconds with leading 0. 00..59
u
Microseconds. 000000..999000
I
DST observed. 0, 1
Timezone and others
Format
Description
Example for Asia/Singapore
O
GMT timezone offset in hours.
+0800
P
GMT timezone offset in hours, including colon
+08:00
Z
GMT timezone offset in seconds.
28800
c
ISO-8601 datetime
1970-01-01T00:00:00+08:00
r
RFC 2822 date.
U
Seconds since UNIX epoch.
Output
Returns the formatted date.
String/Text
Callback
N/A
Video
Coming soon.
Example
Sunday, 01 January 2023
01/01/2023 00:00:00 +08:00
2023-01-01T00:00:00+08:00
ISO-8601 datetime
Links
Last updated
