Filter on date AND time

If you are experiencing problems with "Everything", post here for assistance.
Post Reply
CrxtJ7tOs4Iq
Posts: 28
Joined: Wed Jan 14, 2015 2:19 pm

Filter on date AND time

Post by CrxtJ7tOs4Iq » Mon Jun 19, 2017 12:52 pm

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
Posts: 28
Joined: Wed Jan 14, 2015 2:19 pm

Re: Filter on date AND time

Post by CrxtJ7tOs4Iq » Mon Jun 19, 2017 1:02 pm

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
Posts: 28
Joined: Wed Jan 14, 2015 2:19 pm

Re: Filter on date AND time

Post by CrxtJ7tOs4Iq » Mon Jun 19, 2017 1:06 pm

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
Posts: 2153
Joined: Wed May 24, 2017 9:22 pm

Re: Filter on date AND time

Post by NotNull » Mon Jun 19, 2017 1:46 pm

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
Last edited by NotNull on Mon Jun 19, 2017 1:49 pm, edited 1 time in total.

CrxtJ7tOs4Iq
Posts: 28
Joined: Wed Jan 14, 2015 2:19 pm

Re: Filter on date AND time

Post by CrxtJ7tOs4Iq » Mon Jun 19, 2017 1:48 pm

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

David.P
Posts: 7
Joined: Fri May 29, 2020 3:22 pm

Re: Filter on date AND time

Post by David.P » Wed Jul 22, 2020 9:30 pm

NotNull wrote:
Mon Jun 19, 2017 1:46 pm
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
Posts: 2153
Joined: Wed May 24, 2017 9:22 pm

Re: Filter on date AND time

Post by NotNull » Thu Jul 23, 2020 10:20 am

David.P wrote:
Wed Jul 22, 2020 9:30 pm
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
Posts: 7
Joined: Fri May 29, 2020 3:22 pm

Re: Filter on date AND time

Post by David.P » Thu Jul 23, 2020 11:10 am

NotNull wrote:
Thu Jul 23, 2020 10:20 am
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:
void wrote:
Fri Oct 06, 2017 10:05 pm
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
Posts: 2153
Joined: Wed May 24, 2017 9:22 pm

Re: Filter on date AND time

Post by NotNull » Thu Jul 23, 2020 11:45 am

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
Posts: 7
Joined: Fri May 29, 2020 3:22 pm

Re: Filter on date AND time

Post by David.P » Thu Jul 23, 2020 12:16 pm

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"):
adventurepark42 wrote:
Sun Oct 01, 2017 8:06 am
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
Posts: 2153
Joined: Wed May 24, 2017 9:22 pm

Re: Filter on date AND time

Post by NotNull » Thu Jul 23, 2020 4:02 pm

David.P wrote:
Thu Jul 23, 2020 12:16 pm
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
Posts: 7
Joined: Fri May 29, 2020 3:22 pm

Re: Filter on date AND time

Post by David.P » Thu Jul 23, 2020 5:10 pm

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
Posts: 2153
Joined: Wed May 24, 2017 9:22 pm

Re: Filter on date AND time

Post by NotNull » Thu Jul 23, 2020 8:17 pm

David.P wrote:
Thu Jul 23, 2020 5:10 pm
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
Posts: 236
Joined: Thu Jul 13, 2017 9:14 am

Re: Filter on date AND time

Post by tuska » Thu Jul 23, 2020 10:22 pm

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]
Last edited by tuska on Fri Jul 24, 2020 8:36 am, edited 2 times in total.

David.P
Posts: 7
Joined: Fri May 29, 2020 3:22 pm

Re: Filter on date AND time

Post by David.P » Thu Jul 23, 2020 10:43 pm

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

Image

Post Reply