Date.From

Date.From is a Power Query M function that returns a date value from the given value, with an optional culture parameter. The function returns a date value based on the input type.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

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

Description

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.

Examples

Convert 43910 to a date value.

// Output: #date( 2020, 3, 20 )
Date.From( 43910 )

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

// Output: #date( 1899, 12, 30 )
Date.From( #datetime( 1899, 12, 30, 06, 45, 12 ) )

Other functions related to Date.From are:

BI Gorilla Youtube Channel

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/date-from
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.