Converts an input expression to a date data type.

​Syntax

TO_DATE(Date Value)

​Arguments

Date Value:

A date or datetime field that you want to convert to a Date data type. The most common use is {LocalToday}. A date datatype is required for certain functions like Extract, Year, Month, etc.

​Example

TO_DATE('2019-01-01') = 1/1/2019
​
For this example, {LocalToday} = '2019-02-20'
​
TO_DATE({LocalToday}) = 2/20/2019