convertToDate

Use the convertToDate function to change a Text date value to a DateTime value. The convertToDate function supports ISO 8601 and local formats, or you can define a custom date format to convert the Text date value to.

Function format

convertToDate(Text date value, Text date format)

  • date value: the value which is converted to a DateTime value.
  • date format (optional): the customized date format to convert the Text date value to. The DateTime Text must match the DateTime format Text. See Custom date format options.

If you do not define a custom DateTime format, the function first attempts to parse the Text date value in the ISO 8601 format. If the ISO 8601 format is not applicable, the function attempts to parse the DateTime Text in the local formats. 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

convertToDate example

convertToDate("17/8/2018 1:30:12 am", "DD/M/YYYY, h:mm:ss a")

The formula returns the DateTime value 17/8/2018 1:30:12.