ToDate
Converts a timestamp or text value to a date.
Variants
ToDate(Text text)
Converts the text value into a date.
Parameters
- text
- The text value you want to convert.
Returns
Date
Remarks
The text can be in several popular date formats, including "January 15, 2012", "1/15/12", "2012/1/15", or "1-15-2012".
Examples
ToDate("January 15, 2012")returns the date value 1/15/2012.ToDate("1/15/12")returns the date value 1/15/2012.ToDate("2012/1/15")returns the date value 1/15/2012.ToDate("1-15-2012")returns the date value 1/15/2012.
ToDate(Timestamp timestamp)
Converts the timestamp into a date by returning the date, in the local time zone, in which the timestamp falls.
Parameters
- timestamp
- The timestamp value you want to convert.
Returns
Date
Examples
ToDate(#2013-03-25 11:28:57#)returns the date value 3/25/2013.