DateParse
The DateParse function parses text values in a specified format and generates output in ISO date time format.
For more information (including use case exercises) about date functions, see the Common Date Functions and Use Cases QuickStart.
Syntax
DateParse(text, format)
Function arguments:
- text (required) - the text value to parse
-
format (required) - the date and time format of the text to be parsed (see format options)
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 text dates with the specified format (e.g.,
03/Sep/2020:03:12:38) and returns the equivalent ISO date time (e.g.,2020-09-03 03:12:38).
DateParse([Text Date], "%d/%b/%Y")
- Parses a column of text dates with the specified format (e.g.,
03/Sep/2020) and returns the equivalent ISO date time (e.g.,2020-09-03 00:00:00).
DateParse([Text Date], "[%d/%b/%Y]")
- Parses a column of text dates with the specified format (e.g.,
03/Sep/2020) and returns the equivalent ISO date time (e.g.,2020-09-03 00:00:00).