History file last run date format

If you are experiencing problems with "Everything", post here for assistance.
Post Reply
sk2107
Posts: 326
Joined: Sun Aug 07, 2022 8:48 pm

History file last run date format

Post by sk2107 »

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.
void
Developer
Posts: 16773
Joined: Fri Oct 16, 2009 11:31 pm

Re: History file last run date format

Post by void »

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
sk2107
Posts: 326
Joined: Sun Aug 07, 2022 8:48 pm

Re: History file last run date format

Post by sk2107 »

Perfect. Thanks a Lot.

Best Regards,
Post Reply