Date.From

Syntax

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

About

Returns a date value from the given value. 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. See 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 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.

Date.From(43910)

#date(2020, 3, 20)

Example 2

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

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

#date(1899, 12, 30)