isDate
Use the isDate function to check if a Text value contains DateTime value. The isDate function supports ISO 8601 and local formats, or you can define a date format to check for. The function returns a Boolean value.
Function format
isDate(Text date, Text date format)
- date:the value which is checked for a DateTime type.
- date format (optional): the customized Date format to check the Text date value for. See Custom date format options.
If you do not define a custom date format, the function first attempts to check the Text date value for a date in the ISO 8601 format. If a date does not exist in Text date in the ISO 8601 format, the function attempts to check the Text date for a date in the local format. See Localized formats.
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 |
Time | LT | 8:30 PM |
Time with seconds | LTS | 8:30:25 PM |
Month numeral, day of month, year | L | 09/04/1986 |
l | 9/4/1986 | |
Month name, day of month, year | LL | September 4, 1986 |
ll | Sep 4, 1986 | |
Month name, day of month, year, time | LLL | September 4, 1986 8:30 PM |
lll | Sep 4, 1986 8:30 PM | |
Month name, day of month, day of week, year, time | LLLL | Thursday, September 4, 1986 8:30 PM |
llll | Thu, Sep 4, 1986 8:30 PM |
isDate example
isDate("17/8/2018 1:30:12 am", "DD/M/YYYY, h:mm:ss a")
The formula returns the Boolean value True.