DateTime.ToRecord

Syntax

DateTime.ToRecord(dateTime as datetime) as record

About

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.

Example 1

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

Usage

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

Output

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