Power Query
Search…
Date.ToRecord

Date.ToRecord

Returns a record containing parts of the date value.
function (date as date) as record

Description

Returns a record containing the parts of the given date value, date.

Category

Date

Examples

Convert the #date(2011, 12, 31) value into a record containing parts from the date value.
1
Date.ToRecord(#date(2011, 12, 31))
Copied!
[ Year = 2011, Month = 12, Day = 31 ]