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.
Date.ToRecord(#date(2011, 12, 31))
[ Year = 2011, Month = 12, Day = 31 ]
Copy link
On this page
Date.ToRecord
Description
Category
Examples