Public Declare Function FileTimeToSystemTime Lib "kernel32" (lpFileTime As FILETIME, lpSystemTime As SYSTEMTIME) As Long
Public Type FILETIME
dwLowDateTime As Long
dwHighDateTime As Long
End Type
Public Type SYSTEMTIME
wYear As Integer
wMonth As Integer
wDayOfWeek As Integer
wDay As Integer
wHour As Integer
wMinute As Integer
wSecond As Integer
wMilliseconds As Integer
End Type
Function ChangeTime(mFiletime As FILETIME) As Date
Dim mSystemTime As SYSTEMTIME
FileTimeToSystemTime mFiletime, mSystemTime
ChangeTime = Format(mSystemTime.wYear & "-" & mSystemTime.wMonth & "-" & mSystemTime.wDay, "YYYY-MM-DD")