Date.From
Date.From(value as any, optional culture as nullable text) as nullable date
Returns a date value from the given value.
value
: The value to covert to a date. If the given value isnull
, this function returnsnull
. If the given value isdate
,value
is returned. Values of the following types can be converted to adate
value:text
: Adate
value from textual representation. Refer to Date.FromText for details.datetime
: The date component of thevalue
.datetimezone
: The date component of the local datetime equivalent ofvalue
.number
: The date component of the datetime equivalent of a floating-point number whose integral component is the number of days before or after midnight, 30 December 1899, and whose fractional component represents the time on that day divided by 24. For example, midnight, 31 December 1899 is represented by 1.0; 6 A.M., 1 January 1900 is represented by 2.25; midnight, 29 December 1899 is represented by -1.0; and 6 A.M., 29 December 1899 is represented by -1.25. The base value is midnight, 30 December 1899. The minimum value is midnight, 1 January 0100. The maximum value is the last moment of 31 December 9999.
If
value
is of any other type, an error is returned.culture
: The culture of the given value (for example, "en-US").
Convert the specified date and time to a date value.
Usage
Date.From(#datetime(1899, 12, 30, 06, 45, 12))
Output
#date(1899, 12, 30)
Convert the specified number to a date value.
Usage
Date.From(43910)
Output
#date(2020, 3, 20)
Convert the German text dates in the Posted Date column to date values.
Usage
let
Source = #table(type table [Account Code = text, Posted Date = text, Sales = number],
{
{"US-2004", "20 Januar 2023", 580},
{"CA-8843", "18 Juli, 2023", 280},
{"PA-1274", "12 Januar, 2022", 90},
{"PA-4323", "14 April 2023", 187},
{"US-1200", "14 Dezember, 2022", 350},
{"PTY-507", "4 Juni, 2023", 110}
}),
#"Filtered rows" = Table.TransformColumns(
Source,
{"Posted Date", each Date.From(_, "de-DE"), type date}
)
in
#"Filtered rows"
Output
#table(type table [Account Code = text, Posted Date = date, Sales = number],
{
{"US-2004", #date(2023, 1, 20), 580},
{"CA-8843", #date(2023, 7, 18), 280},
{"PA-1274", #date(2022, 1, 12), 90},
{"PA-4323", #date(2023, 4, 14), 187},
{"US-1200", #date(2022, 12, 14), 350},
{"PTY-507", #date(2023, 6, 4), 110}
})