Date.ToRecord
The function retrieves a record that includes the components of the specified date value, date.date: This is the date value used to calculate the individual parts of the record.
The function retrieves a record that includes the components of the specified date value, date.date: This is the date value used to calculate the individual parts of the record.
Transform the date value #date(2011, 12, 31) into a record that includes components of the date value. In Power Query, the function MDate.ToRecord(#date(2011, 12, 31)) should be used for this purpose. The output of this operation will be displayed in Power Query as follows: [Year = 2011, Month = 12, Day = 31].