Power Query
published
Search
K
Comment on page

DateTime.ToRecord

DateTime.ToRecord

Returns a record containing the datetime value's parts.
function (dateTime as datetime) as record

Description

Returns a record containing the parts of the given datetime value, dateTime.

Category

DateTime

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))
[ Year = 2011, Month = 12, Day = 31, Hour = 11, Minute = 56, Second = 2 ]