Date.ToRecord

Syntax

Date.ToRecord(date as date) as record

About

Returns a record containing the parts of the given date value, date.

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

Example 1

Convert the #date(2011, 12, 31) value into a record containing parts from the date value.

Usage

Date.ToRecord(#date(2011, 12, 31))

Output

[
      Year = 2011,
      Month = 12,
      Day = 31
]