DateTime.ToRecord

This function will return a record that includes the individual components of the specified datetime value, dateTime.dateTime. The input parameter dateTime.dateTime should be a datetime value from whi...

Syntax

DateTime.ToRecord(dateTime as datetime) as record

About

This function will return a record that includes the individual components of the specified datetime value, dateTime.dateTime. The input parameter dateTime.dateTime should be a datetime value from which the parts of the record will be derived.

Explanation

Transform the #datetime(2011, 12, 31, 11, 56, 2) value into a data structure with separate Date and Time components. It can be achieved by using the Power Query MDateTime.ToRecord function with the input value of #datetime(2011, 12, 31, 11, 56, 2). The resulting output will be as follows: [ Year = 2011, Month = 12, Day = 31, Hour = 11, Minute = 56, Second = 2].