Hello,
I tried to browse the history file and could not figure the last run date as it comes in this forma:
133556790366334000
133554195847464000
133438431420909000
133411736500975000
133411724035671000
133411715121749000
133401420054490000
133409199042733000
133409064352590000
How can I display them in windows format, as the file is CSV it opens normally using excel.
Regards.
History file last run date format
Re: History file last run date format
Everything stores dates as FILETIMEs.
To convert a FILETIME to a date in excel, use the following formula:
=((C2-116444736000000000)/864000000000)+DATE(1970,1,1)
where C2 is the cell to convert from a FILETIME to date.
FILETIMEs are in UTC.
Last Search Date format in Search History.csv
To convert a FILETIME to a date in excel, use the following formula:
=((C2-116444736000000000)/864000000000)+DATE(1970,1,1)
where C2 is the cell to convert from a FILETIME to date.
FILETIMEs are in UTC.
Last Search Date format in Search History.csv
Re: History file last run date format
Perfect. Thanks a Lot.
Best Regards,
Best Regards,