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.

DateTime.ToRecord(#datetime(2011, 12, 31, 11, 56, 2))
Year 2011
Month 12
Day 31
Hour 11
Minute 56
Second 2