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).

Related Functions


Additional Resources


Was this page helpful?
Yes No