DateTime.ToRecord

Returns a record containing the datetime value's parts.

Syntax

DateTime.ToRecord(
    dateTime as datetime
) as record

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

dateTime: A datetime value for from which the record of its parts is to be calculated.

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

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

Result:

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