DateTime.ToRecord

Updated on

DateTime.ToRecord is a Power Query M function that extracts the parts of a given datetime value as a record. The function returns a record containing the year, month, day, hour, minute, second, and fraction of a second.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

DateTime.ToRecord( dateTime as datetime ) as record

Description

Time.ToRecord takes a time value and decomposes it into a detailed record. Specifically, it processes a time input and outputs a record format that includes the individual components of the time value, such as hours, minutes, and seconds.

Examples

Convert the #datetime( 2011, 12, 31, 11, 56, 2 ) value into a record containing Date and Time values.

DateTime.ToRecord( #datetime( 2011, 12, 31, 11, 56, 2 ) )

 /* Output: 
[
      Year = 2011,
      Month = 12,
      Day = 31,
      Hour = 11,
      Minute = 56,
      Second = 2
]
 */ 

Other functions related to DateTime.ToRecord are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/datetime-torecord