DateTimeZone.FromFileTime

Generates a datetimezone value by converting the fileTime value to the local time zone. FileTime is a Windows file time value that indicates the quantity of 100-nanosecond intervals passed since 12:00...

Syntax

DateTimeZone.FromFileTime(fileTime as nullable number) as nullable datetimezone

About

Generates a datetimezone value by converting the fileTime value to the local time zone. FileTime is a Windows file time value that indicates the quantity of 100-nanosecond intervals passed since 12:00 midnight on January 1, 1601 A.D. (C.E.) Coordinated Universal Time (UTC).

Explanation

Transform the numeric value 129876402529842245 into a datetimezone format using the Power Query M function MDateTimeZone.FromFileTime(129876402529842245). The resulting output will be #datetimezone(2012, 7, 24, 14, 50, 52.9842245, -7, 0).