Change from FILETIME to DATETIME

If you are experiencing problems with "Everything", post here for assistance.
Post Reply
SigTill
Posts: 6
Joined: Wed Jul 12, 2017 6:04 pm

Change from FILETIME to DATETIME

Post by SigTill »

When using the command line:

https://www.voidtools.com/support/every ... e_options/

"Everything.exe" -create-file-list "c:\temp\test.csv" "c:\temp\"

This returns FILETIME on Date Modified and Date Created.

When I export from the GUI it saves as "normal datetime"

How can I add the NORMAL datetime as an export through CLI?
SigTill
Posts: 6
Joined: Wed Jul 12, 2017 6:04 pm

Re: Change from FILETIME to DATETIME

Post by SigTill »

Totally noob - had to use the es.exe - and not the Everything.exe!
void
Developer
Posts: 16750
Joined: Fri Oct 16, 2009 11:31 pm

Re: Change from FILETIME to DATETIME

Post by void »

Please try exporting to csv from es with the -export-csv command line option.

To convert 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.

https://stackoverflow.com/questions/421 ... excel-date

The reason for using FILETIME in efu files is the very high (100 nanosecond) resolution.
Post Reply