Date.From

  • Article

Syntax

Date.From(value as any, optional culture as nullable text) as nullable date

About

Returns a date value from the given value. An optional culture> may also be provided (for example, "en-US"). If the given value is null, Date.From returns null. If the given value is date, value is returned. Values of the following types can be converted to a date value:

  • text: A date value from textual representation. Refer to Date.FromText for details.
  • datetime: The date component of the value.
  • datetimezone: The date component of the local datetime equivalent of value.
  • number: The date component of the datetime equivalent of the OLE Automation Date expressed by value.

If value is of any other type, an error is returned.

Example 1

Convert 43910 to a date value.

Usage

Date.From(43910)

Output

#date(2020, 3, 20)

Example 2

Convert #datetime(1899, 12, 30, 06, 45, 12) to a date value.

Usage

Date.From(#datetime(1899, 12, 30, 06, 45, 12))

Output

#date(1899, 12, 30)