Filter on date AND time

[CrxtJ7tOs4Iq]

I have looked around and cant seem to find an answer.
This works great DM:1/1/1080
but i cant make this work DM: 1/1/1980 6:00 PM

Does anyone have any tips for this?

[CrxtJ7tOs4Iq]

After some more digging i found this.
If you wish to specify dates with times, please use ISO 8601 dates:
But i still cant seem to get it to work correctly.

[CrxtJ7tOs4Iq]

It seems like it works on my copy of ES version 1.4.1.877 (x86)
but not on my copy that is version 1.4.0.713b (x64) so i will update and see if that solves my problem.

[NotNull]

Try this: DM:1980-01-01T18:00

That's ISO8601 syntax: YYYY-MM-DDTHourHour:MinMin:SecSec

[*] A literal "T" is the separator to indicate taht a time will follow.
[*] Use prefix zero if needed.
[*] Hour is 0..24
[*] You don't have to specify minutes and seconds; T18 will give you all results between 18:00:00 and 18:59:59

[CrxtJ7tOs4Iq]

I got it working. Thanks
I think maybe it was just to old of a version?

[David.P]

Try this: DM:1980-01-01T18:00

That's ISO8601 syntax: YYYY-MM-DDTHourHour:MinMin:SecSec

[*] A literal "T" is the separator to indicate that a time will follow.
[*] Use prefix zero if needed.
[*] Hour is 0..24
[*] You don't have to specify minutes and seconds; T18 will give you all results between 18:00:00 and 18:59:59

Hi, I can't get this to work at all. The time of day (e.g. T18:00) seems to get ignored.

Any ideas greatly appreciated

[NotNull]

Hi, I can't get this to work at all. The time of day (e.g. T18:00) seems to get ignored.

So, what was your query and what was the output?

Just tested with

dm:2020-07-22T23

and it correctly showed me all 300 files that were modified yesterday between 23:00 and 23:59:59


(Everything 1.4.1.976 x64)

[David.P]

Just tested with

dm:2020-07-22T23

and it correctly showed me all 300 files that were modified yesterday between 23:00 and 23:59:59

Thanks, this indeed does work. However, I'd love to do something like this:

dm:2020T23

Even @void said that it should work:

Please try searching for:

Code: Select all

dc:2017-08-01-2017-09-01T23:32

Note the year-month-day order.
Follow the date with a T and the 24-hour time.

http://www.voidtools.com/support/everything/searching/#date_syntax

However, it doesn't seem to even be implemented, right?

[NotNull]

I guess @void misinterpreted the question as that does not give the expected results (all files modified at 22H23 in august 2107)

Not possible (as stated in the other thread you linked).
You would need a new function, something like tm: (timemodified:) for that.

[David.P]

Yeah but his example

dc:2017-08-01-2017-09-01T23:32

clearly is directed to a date range AND a time of day, which also was what the OP was after (other than he wanted "dc" where I'm looking for "dm"):

While doing a long-time timelapse i need to find images that are created at the same time over a peroid of 12month.
is there a way to just search for creation time?

But @voids example doesn't even work with "dc"?!

[NotNull]

But @voids example doesn't even work with "dc"?!

It does. It reports all files and folders that were created between 2017-08-01, 00H00 and 2017-09-01, 23H32.

Did you add the Date Created column to the result list or are you looking at the Date Modified column?


Date created is not indexed by default. If you want dc: results quickly, it is recommended to index it (Menu:Tools > Options > Indexes)

[David.P]

Thanks!
I can now see that

dc:2017-08-01-2017-08-02T14:31

or

dc:(2017-08-01-2017-08-02)T14:31

indeed works -- however different from what the OP was after (find files with a certain time of day irrespective of the date, or in an entire date range).

Bummer that there seems to be not one tool available that can do this

[NotNull]

Bummer that there seems to be not one tool available that can do this

Just tried it in Total Commander. It should be able to find file based on time, although I could not get the syntax right (after 20 seconds ..)

It certainly is possible with a Powershell script. This simple demo will give you all files in a folder with a creation time between 12H00 and 14H59:

Code: Select all

 gci | where { ($_.CreationTime).Hour -in 12 ..14} | % {$_.FullName }

(Didn't check for timezone/ daylight saving time offset; it is just a simple demo).

[tuska]

Total Commander
Search... Alt+F7

Code: Select all

☑ Search in plugins
Plugin:	  Property:     OP: Value:
tc	  creationtime  =   12.52.39
More rules -> ◉ OR (any match)
tc	  writetime     =   20.44.22
************************************
☑ Search in plugins
Plugin:	  Property:     OP: Value:
tc        creationdate  >=  01.01.2019
More rules -> ◉ AND (all match)
tc	  creationdate  <=  26.04.2019
More rules
tc	  creationtime  =   19.56.56

"Configure this custom columns view...":

Code: Select all

[=tc.creationdate.D.M.Y h:m:s]
[=tc.writedate.D.M.Y h:m:s]
[=tc.accessdate.D.M.Y h:m:s]

[David.P]

Aaaahhhhg just found that Dopus the King of all file managers of course can do it perfectly: