This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Download Microsoft Edge
More info about Internet Explorer and Microsoft Edge
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)