ToDate

Converts a timestamp or text value to a date.

Variants

ToDate(Text text)

Converts the text value in the YYYY-MM-DD format into a date.

Parameters

text
The text value you want to convert.

Returns

Date

Examples

ToDate(Text text, Text culture)

Converts the text value into a date using the specified culture.

Parameters

text
The text value you want to convert.
culture
The culture name.

Returns

Date

Examples

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(Timestamp timestamp, Text timezone)

Converts the timestamp into a date by returning the date, in the specified time zone, in which the timestamp falls.

Parameters

timestamp
The timestamp value you want to convert.
timezone
The timezone to convert timestamp argument to, out of the list of valid timezone identifiers.

Returns

Date

Examples