DateParse

The DateParse function parses a text value in a specified format and returns a date value in ISO date time format.

πŸ’‘

If the input is a text or number value that reflects ISO (yyyy-mm-dd or yyyy-mm-dd hh:mm:ss) or Unix time format, you can use the Date function, which doesn't require you to specify the input format.

Syntax

DateParse(text, format)

Function arguments:

text(required) The text value of column of text values to parse.
format(required) The date time format of the text value.

For information about date time format strings, see Define custom date formats.

Examples

DateParse("03-Sep-2020:03:05:13", "%d-%b-%Y:%H:%M:%S")

Returns the ISO date time 2020-09-03 03:05:13.

DateParse(\[Text Date\], "%d/%b/%Y:%H:%M:%S")

Parses values in the Text Date column using the specified format and returns the equivalent ISO date time. For example, the function parses Text Date value 03/Sep/2020:03:12:38 and returns 2020-09-03 03:12:38.

DateParse(\[Text Date\], "%d/%b/%Y")

Parses values in the Text Date column using the specified format and returns the equivalent ISO date time. For example, the function parses Text Date value 03/Sep/2020 and returns 2020-09-03 00:00:00.