Power Query
Search…
DateTime.FromFileTime

DateTime.FromFileTime

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

Description

Creates a datetime 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

DateTime

Examples

Convert 129876402529842245 into a datetime value.
1
DateTime.FromFileTime(129876402529842245)
Copied!

datetime(2012, 7, 24, 14, 50, 52.9842245)