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

Screen_Shot_2020-09-14_at_11.52.43_AM.png

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

Screen_Shot_2020-09-14_at_11.48.49_AM.png

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

Screen_Shot_2020-09-14_at_11.49.49_AM.png

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

Screen_Shot_2020-09-14_at_11.50.38_AM.png

 

Related Documentation

Date Functions Overview
Date
DateTime

Types of Values