← Back to Date and time functions

DateTime.FromFileTime

This function takes the fileTime value and converts it into a datetime value in the local time zone. The fileTime value is a Windows file time value that calculates the number of intervals in 100-nano...

Syntax

DateTime.FromFileTime(fileTime as nullable number) as nullable datetime

About

This function takes the fileTime value and converts it into a datetime value in the local time zone. The fileTime value is a Windows file time value that calculates the number of intervals in 100-nanoseconds that have passed since 12:00 midnight on January 1, 1601 A.D. (C.E.) Coordinated Universal Time (UTC).

Explanation

To convert the number 129876402529842245 to a datetime value, you can use the Power Query M function MDateTime.FromFileTime(129876402529842245). The output will be #datetime(2012, 7, 24, 14, 50, 52.9842245).