DateParse

Parses a text string representing a date in the specified format and returns the equivalent ISO datetime value Category: date Syntax:

DateParse([text_column], "format")

Returns: String Context Filtering: ✗ No

Parameters

Name	Type	Required	Description
`text_column`	`column or text`	✓ Yes	The text string or column of text strings to parse
`format`	`text`	✓ Yes	The datetime format of the text string using format specifiers (e.g., %Y, %m, %d, %H, %M, %S, %B, %b, etc.)

Allowed Column Types for text_column: STRING, TEXT

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

Parses the text string and returns the equivalent ISO datetime value Result: 2020-09-03 03:05:13

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

Parses text strings in the Text Date column using the specified format

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

Parses text strings in the Text Date column using date format only

Last modified on March 6, 2026