What is the search syntax for time of day also, ie not just the date?

General discussion related to "Everything".
Post Reply
frew
Posts: 45
Joined: Tue Apr 28, 2015 2:16 am

What is the search syntax for time of day also, ie not just the date?

Post by frew »

Hello,

I search for a bunch of music files on my computer.

I sort the results by date modified.

I want to get more specific and show only results, for example, that are date modified after

10-13-03 7:13pm

I know how to do the day month and year,
for example, dm:>10-13-03 works great.

Yet I can't figure out the syntax for the time of day.

I'm not sure what the Thh means below.

Also, I'm not sure where to put in and required colons, dashes, and/or brackets.

Everything Help> Search Syntax:
"
Date Syntax:
. . .
YYYY[-MM[-DD[Thh[:mm[:ss[.sss]]]]]]
YYYYMM[DD[Thh[mm[ss[.sss]]]]]
FILETIME (>99999999)
"

Thanks for any help with this.
froggie
Posts: 301
Joined: Wed Jun 12, 2013 10:43 pm

Re: What is the search syntax for time of day also, ie not just the date?

Post by froggie »

Just like this:
dm:2004-06-15T16:04 will find a file with this time modified field in the results list ==> 6/15/2004 4:04 PM

Note that:
The brackets just show optional parameters in the syntax, they are not used in the search
If you use dashes then you have to use colons
T starts the time field
Hours are based on the 24 hour clock. For PM times add 12 hours
Last edited by froggie on Sat Feb 25, 2023 3:27 pm, edited 1 time in total.
ChrisGreaves
Posts: 684
Joined: Wed Jan 05, 2022 9:29 pm

Re: What is the search syntax for time of day also, ie not just the date?

Post by ChrisGreaves »

froggie wrote: Fri Feb 24, 2023 9:34 pm Just like this:
dm:2004-06-15T16:04 will find a file with this time modified field in the results list ==> dm:2004-06-15T16:04
Thank You!
Chris
frew
Posts: 45
Joined: Tue Apr 28, 2015 2:16 am

Re: What is the search syntax for time of day also, ie not just the date?

Post by frew »

froggie wrote: Fri Feb 24, 2023 9:34 pm Just like this:
dm:2004-06-15T16:04 will find a file with this time modified field in the results list ==> dm:2004-06-15T16:04
Thanks so much.
Yes this works great.
I understand now, with your clear explanations.

An interesting note. I just happened to be going through some old wav audio files, having them sorted by date in Everything.
When I had to to take a break, I noted where I left off, and it happened to be at some wav with the date
2-17-03T18:07
but there were also some wav with the date
2-17-03T18:08
I had checked all the
2-17-03T18:07
so I did not want the wav with the date
2-17-03T18:07
to be showing in the results anymore.

So I tried
dm:>2-17-03T18:07 (figuring the wav dm greater than 6:07pm (ie 6:08pm and later) would be the wav that would show in the results)
Yet the wav dated
2-17-03T18:07
still showed up in the search results.

Then I thought, well, technically, any time at or beyond 6:07pm until 6:08pm is still 6:07pm,
so that must be why
dm:>2-17-03T18:07
still shows wav with the dm
2-17-03T18:07.

So, to get search results to show up that are only only dm
2-17-03T18:08
and later,
instead of using
dm:>2-17-03T18:07
and thus still have the wav dm
2-17-03T18:07
still showing up,
(which just seems kind of counterintuitive to me, as mentioned above),
I use the following instead:
(I know it's a bit unusual perhaps, but what works for me)
!dm:<2-17-03T18:08

ie instead of asking to show wav files dm after 6:07pm and still seeing dm 6:07pm wav files,
I ask instead to show nothing dm before 6:08pm, then only the files I want show up
(ie wav dm 6:08pm and later)
Just a little twist, but works well for me.

Again, thank you so much, your explanations cleared things up for me, much appreciated.
froggie
Posts: 301
Joined: Wed Jun 12, 2013 10:43 pm

Re: What is the search syntax for time of day also, ie not just the date?

Post by froggie »

I use the following instead:
(I know it's a bit unusual perhaps, but what works for me)
!dm:<2-17-03T18:08
How about dm:>2-17-03T18:07:59 or dm:>2-17-03T18:07:59.999


Re-posting my original answer because there was a typo in it.

dm:2004-06-15T16:04 will find a file with this time modified field in the results list ==> 6/15/2004 4:04 PM

Note that:
The brackets just show optional parameters in the syntax, they are not used in the search
If you use dashes then you have to use colons
T starts the time field
Hours are based on the 24 hour clock. For PM times add 12 hours
frew
Posts: 45
Joined: Tue Apr 28, 2015 2:16 am

Re: What is the search syntax for time of day also, ie not just the date?

Post by frew »

froggie wrote: Sat Feb 25, 2023 3:47 pm How about dm:>2-17-03T18:07:59 or dm:>2-17-03T18:07:59.999
Thank you so much!
I like both the options you present here, because they
get the results I want, and
make more sense to me intuitively than my sort of double negative idea.
Thanks again.
Works great.
Post Reply