DateParse parses a Text value into a Date using a provided format.
Usage
DateParse(text, format)
text (required) - The text value to be parsed.
format (required) - The format to apply to the text value when parsing. This is the format represented in the text value. See format options.
For example, the format of "03/Sep/2020:03:05:13" is "%d/%b/%Y:%H:%M:%S", and the format of "03/Sep/2020" is "%d/%b/%Y". DateParse will convert both of these values to "2020-09-03 03:05:13".
Examples
DateParse("03-Sep-2020:03:05:13", "%d-%b-%Y:%H:%M:%S")
DateParse([Text Date], "%d/%b/%Y:%H:%M:%S")
DateParse([Text Date], "%d/%b/%Y")
DateParse([Text Date], "[%d/%b/%Y]")
