DateTimeZone.ToRecord Function in Power Query

The DateTimeZone.ToRecord function in Power Query returns a record containing parts of a DateTimeZone value.

Syntax

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

Example: Let’s convert the datetimezone value into a record containing date, time and timezone.

Power Query M

let
    Source = DateTimeZone.ToRecord(#datetimezone(2025,2,25,4,45,20,5,30))
in
    Source        

The output of the above code is shown in the image below:

The output in the code format is shown below:

Power Query M

[
    Year = 2025,
    Month = 2,
    Day = 25,
    Hour = 4,
    Minute = 45,
    Second = 20,
    ZoneHours = 5,
    ZoneMinutes = 30
]