formatDate
Use the formatDate function to change a DateTime value to a Text value in a local or custom format.
Function format
formatDate(DateTime value, Text date format)
- value: the value which is changed to a Text value in a new format.
- date format: the local format or customized date format to convert the DateTime value to. See Local format options or Custom date format options.
Local format options
Local date formats
|
Local format |
Output example |
|---|---|
| "Short" | 10/9/2018, 10:31 AM |
| "Medium" | Oct 9, 2018, 10:31 AM |
| "Long" | October 9, 2018, 10:31:01 AM |
| "Full" | Tuesday, October 9, 2018 10:33 AM |
| "ShortDate" | 10/9/2018 |
| "MediumDate" | Oct 9, 2018 |
| "LongDate" | October 9, 2018 |
| "ShortTime" | 10:31 AM |
| "MediumTime" | 10:31:01 AM |
Custom date format options
Custom format examples
|
Custom format example |
Output |
|---|---|
|
"dddd, MMMM, Do, YYYY, h:mm:ss a" |
"Sunday, February 14th 2010, 3:25:50 pm" |
|
"ddd, hA" |
"Sun, 3PM" |
Use tokens to define a custom DateTime format in your function.
Format tokens
|
|
Token |
Output |
|---|---|---|
|
Month |
M |
1 2 ... 11 12 |
|
|
Mo |
1st 2nd ... 11th 12th |
|
|
MM |
01 02 ... 11 12 |
|
|
MMM |
Jan Feb ... Nov Dec |
|
|
MMMM |
January February ... November December |
|
Quarter |
Q |
1 2 3 4 |
|
|
Qo |
1st 2nd 3rd 4th |
|
Day of month |
D |
1 2 ... 30 31 |
|
|
Do |
1st 2nd ... 30th 31st |
|
|
DD |
01 02 ... 30 31 |
|
Day of year |
DDD |
1 2 ... 364 365 |
|
|
DDDo |
1st 2nd ... 364th 365th |
|
|
DDDD |
001 002 ... 364 365 |
|
Day of week |
d |
0 1 ... 5 6 |
|
|
do |
0th 1st ... 5th 6th |
|
|
dd |
Su Mo ... Fr Sa |
|
|
ddd |
Sun Mon ... Fri Sat |
|
|
dddd |
Sunday Monday ... Friday Saturday |
|
Day of week (locale) |
e |
0 1 ... 5 6 |
|
Day of week (ISO) |
E |
1 2 ... 6 7 |
|
Week of year |
w |
1 2 ... 52 53 |
|
|
wo |
1st 2nd ... 52nd 53rd |
|
|
ww |
01 02 ... 52 53 |
|
Week of year (ISO) |
W |
1 2 ... 52 53 |
|
|
Wo |
1st 2nd ... 52nd 53rd |
|
|
WW |
01 02 ... 52 53 |
|
Year |
YY |
70 71 ... 29 30 |
|
|
YYYY |
1970 1971 ... 2029 2030 |
|
|
Y |
1970 1971 ... 9999 +10000 +10001 Note: This complies with the ISO 8601 standard for dates past the year 9999 |
|
Week year |
gg |
70 71 ... 29 30 |
|
|
gggg |
1970 1971 ... 2029 2030 |
|
Week year (ISO) |
GG |
70 71 ... 29 30 |
|
|
GGGG |
1970 1971 ... 2029 2030 |
|
AM/PM |
A |
AM PM |
|
|
a |
am pm |
|
Hour |
H |
0 1 ... 22 23 |
|
|
HH |
00 01 ... 22 23 |
|
|
h |
1 2 ... 11 12 |
|
|
hh |
01 02 ... 11 12 |
|
|
k |
1 2 ... 23 24 |
|
|
kk |
01 02 ... 23 24 |
|
Minute |
m |
0 1 ... 58 59 |
|
|
mm |
00 01 ... 58 59 |
|
Second |
s |
0 1 ... 58 59 |
|
|
ss |
00 01 ... 58 59 |
|
Fractional second |
S |
0 1 ... 8 9 |
|
|
SS |
00 01 ... 98 99 |
|
|
SSS |
000 001 ... 998 999 |
|
|
SSSS ... SSSSSSSSS |
000[0..] 001[0..] ... 998[0..] 999[0..] |
|
Time zone |
z or zz |
EST CST ... MST PST Note: as of 1.6.0, the z/zz format tokens have been deprecated from plain moment objects. However, they do work if you are using a specific time zone with the moment-timezone addon. |
|
|
Z |
-07:00 -06:00 ... +06:00 +07:00 |
|
|
ZZ |
-0700 -0600 ... +0600 +0700 |
|
Unix timestamp |
X |
1360013296 |
|
Unix millisecond timestamp |
x |
1360013296123 |
formatDate example 1
In the following example formula, the Form.EndDate DateTime variable value is 09 Oct 2018 - 8:31 AM.
formatDate(Form.EndDate, "DD/MM/YYYY, h:mm a")
This formula returns the date Text value of 09/10/2018, 8:31 am.
formatDate example 2
In the following example formula, the Form.EndDate DateTime variable value is 09 Oct 2018 - 8:31 AM.
formatDate(Form.EndDate, "medium")
This formula returns the date Text value of Oct 9, 2018, 8:31 AM.