Search by time creation only without date on a NAS

General discussion related to "Everything".
Post Reply
JC2
Posts: 2
Joined: Fri Feb 09, 2024 5:00 pm

Search by time creation only without date on a NAS

Post by JC2 »

Hello the experts,

My case is this one:

I have a folder, with hundred of subfolders how contain a lot of snapshots (photo) taken by day by 3 cameras.


I want to find all the snapshots how was taken between 12:00:00 and 12:03:09 for exemple, directly from the main folder.

or

Find one snapshot taken at 12:01:07 for exemple in all subfolders

or

Find one snapshot taken between 12:00:00 and 13:00:00 in all subfolders

After one of this research, the result'll be sort by day

Then, I'll copy-paste all the snapshots to make a film (quick motion) to see the building of my house for exemple;

Any idea to help me?

I've tried 3 days to find the solution but I haven't find it.

Thank you in advance :idea:
void
Developer
Posts: 16770
Joined: Fri Oct 16, 2009 11:31 pm

Re: Search by time creation only without date on a NAS

Post by void »

Everything is designed to search for year-month-day hour:minute:second


I want to find all the snapshots how was taken between 12:00:00 and 12:03:09 for exemple, directly from the main folder.

Code: Select all

"c:\main\folder\*" (HOUR($date-taken:)*60*60)+(MINUTE($date-taken:)*60)+(SECOND($date-taken:))>=(12*60*60)+(0*60)+(0) (HOUR($date-taken:)*60*60)+(MINUTE($date-taken:)*60)+(SECOND($date-taken:))<=(12*60*60)+(3*60)+(9)
(converts time to total seconds and compares total seconds >=12:00:00 and <=12:03:09)

I think Everything needs a Time Taken property..


Find one snapshot taken at 12:01:07 for exemple in all subfolders
"c:\main\folder\" HOUR($date-taken:)==12 MINUTE($date-taken:)==01 SECOND($date-taken:)==07


Find one snapshot taken between 12:00:00 and 13:00:00 in all subfolders
"c:\main\folder\" HOUR($date-taken:)==12



I recommend the following search to find one snapshot per day:

"c:\main\folder\" HOUR($date-taken:)==12 a:=formatfiletime($date-taken:,"YYYYMMDD") distinct:a



Add the Date Taken column (Result List Column Header -> Right click -> Add Columns...)
Click the Date Taken column column header to sort by Date Taken.
JC2
Posts: 2
Joined: Fri Feb 09, 2024 5:00 pm

Re: Search by time creation only without date on a NAS

Post by JC2 »

Hi,

Thank you for reply but nothing is working;
Capture1.PNG
Capture1.PNG (33.99 KiB) Viewed 3027 times
For exemple:
Capture2.PNG
Capture2.PNG (9.03 KiB) Viewed 3027 times
An idea why it doesn't work?

Thank you
void
Developer
Posts: 16770
Joined: Fri Oct 16, 2009 11:31 pm

Re: Search by time creation only without date on a NAS

Post by void »

Everything 1.4 doesn't have the option to search for just time.

If you would like to search for time, please check out the Everything 1.5 alpha
void
Developer
Posts: 16770
Joined: Fri Oct 16, 2009 11:31 pm

Re: Search by time creation only without date on a NAS

Post by void »

Everything 1.5.0.1368a adds support for searching time with ISO8601 and wildcards.


Syntax:

YYYY-MM-DDTHH:mm:ss
*-*-*T*:*:*



You can combine *-*-* into a single *



Example usage:

date-taken:*-02
date-taken:*T9:00..*T17:00
date-taken:*-12-31
anmac1789
Posts: 669
Joined: Mon Aug 24, 2020 1:16 pm

Re: Search by time creation only without date on a NAS

Post by anmac1789 »

void wrote: Thu Feb 29, 2024 6:50 am Everything 1.5.0.1368a adds support for searching time with ISO8601 and wildcards.

Example usage:

date-taken:*-02
date-taken:*T9:00..*T17:00
nice one this will be a useful feature
anmac1789
Posts: 669
Joined: Mon Aug 24, 2020 1:16 pm

Re: Search by time creation only without date on a NAS

Post by anmac1789 »

Can this use for example date-taken:*-12-31 (for all files which have date taken Dec 31, YYYY for all years) ?

edit: nvm answered my own question. Sorry
void
Developer
Posts: 16770
Joined: Fri Oct 16, 2009 11:31 pm

Re: Search by time creation only without date on a NAS

Post by void »

Yes, all date search functions will support ISO8601 wildcards.
anmac1789
Posts: 669
Joined: Mon Aug 24, 2020 1:16 pm

Re: Search by time creation only without date on a NAS

Post by anmac1789 »

void wrote: Thu Feb 29, 2024 11:29 pm Yes, all date search functions will support ISO8601 wildcards.
Ok, thank you void
Post Reply