Power Query
published
Search
⌃K

DateTimeZone.FromFileTime

DateTimeZone.FromFileTime

Creates a datetimezone from a 64 bits long number.
function (optional fileTime as nullable any) as nullable any

Description

Creates a datetimezone value from the fileTime value and converts it to the local time zone. The filetime is a Windows file time value that represents the number of 100-nanosecond intervals that have elapsed since 12:00 midnight, January 1, 1601 A.D. (C.E.) Coordinated Universal Time (UTC).

Category

DateTimeZone

Examples

Convert 129876402529842245 into a datetimezone value.
DateTimeZone.FromFileTime(129876402529842245)

datetimezone(2012, 7, 24, 14, 50, 52.9842245, -7, 0)