DateTimeZone.ToRecord

This function retrieves a dataset that includes the components of the specified datetimezone value. dateTimeZone: The datetimezone value from which the dataset of its components will be generated.

Transform the #datetimezone(2011, 12, 31, 11, 56, 2, 8, 0) value into a record that includes separate Date, Time, and Zone values. Use Power Query MDateTimeZone.ToRecord() function to achieve this conversion. The resulting record will display the following components: Year = 2011, Month = 12, Day = 31, Hour = 11, Minute = 56, Second = 2, ZoneHours = 8, and ZoneMinutes = 0.