Power Query
published
Search
⌃K

Date.From

Date.From

Creates a date from the given value.
function (optional value as nullable any, optional culture as nullable any) as nullable any

Description

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:
If value is of any other type, an error is returned.

Category

Date

Examples

Convert 43910 to a date value.
Date.From(43910)

date(2020, 3, 20)

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)