Searching for *.xls files modified yesterday

bknight
BronzeLounger
Posts: 1389
Joined: 08 Jul 2016, 18:53

Searching for *.xls files modified yesterday

Post by bknight »

I've been attempting to find a way to search for *.xks file modifies/created yesterday. Win 10 gives me the ability to search for files modified yesterday or *.xls file. Now I need a way of combing the two.

User avatar
HansV
Administrator
Posts: 78474
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Searching for *.xls files modified yesterday

Post by HansV »

Enter the following in the search box:

*.xls datemodified:yesterday
Best wishes,
Hans

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15615
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Re: Searching for *.xls files modified yesterday

Post by ChrisGreaves »

bknight wrote:
21 Apr 2023, 10:25
I've been attempting to find a way to search for *.xls file modifies/created yesterday. Win 10 gives me the ability to search for files modified yesterday or *.xls file. Now I need a way of combing the two.
SimpleSearch07.png

Code: Select all

ext:xls dm:=20230420
I have given up on using Windows Explorer for searches. I use Everything.
Don't forget the colons, don't add superfluous spaces.
I posted an overview in this topic
This post shows how to search by four dates.

Cheers, Chris
You do not have the required permissions to view the files attached to this post.
There's nothing heavier than an empty water bottle

bknight
BronzeLounger
Posts: 1389
Joined: 08 Jul 2016, 18:53

Re: Searching for *.xls files modified yesterday

Post by bknight »

I've never used that syntax before. No files found and I know that at least a half dozen or so where modified yesterday. The file in question is a .csv downloaded and then extra worksheets added to it and saved(not as a .csv) as some name last night. would date created be dc:20230420?
You do not have the required permissions to view the files attached to this post.

bknight
BronzeLounger
Posts: 1389
Joined: 08 Jul 2016, 18:53

Re: Searching for *.xls files modified yesterday

Post by bknight »

Here is an image of one of my directories notice the files saved in the ~1900 hr.
You do not have the required permissions to view the files attached to this post.

User avatar
stuck
Panoramic Lounger
Posts: 8176
Joined: 25 Jan 2010, 09:09
Location: retirement

Re: Searching for *.xls files modified yesterday

Post by stuck »

bknight wrote:
21 Apr 2023, 10:59
I've never used that syntax before. No files found...
You can't use the syntax proposed by Chris in the Windows search box, that syntax will only work if you use the dedicated search application 'Everything'.

Use the syntax given by Hans:

Ken

bknight
BronzeLounger
Posts: 1389
Joined: 08 Jul 2016, 18:53

Re: Searching for *.xls files modified yesterday

Post by bknight »

HansV wrote:
21 Apr 2023, 10:39
Enter the following in the search box:

*.xls datemodified:yesterday
I didn't see your comment when I refreshed. I still didn't find the file I worked on for about an hour last night, maybe I hit the cancel instead of save. You suggestion found all the normal saved files.
Thanks Ken
You do not have the required permissions to view the files attached to this post.

User avatar
ChrisGreaves
PlutoniumLounger
Posts: 15615
Joined: 24 Jan 2010, 23:23
Location: brings.slot.perky

Re: Searching for *.xls files modified yesterday

Post by ChrisGreaves »

stuck wrote:
21 Apr 2023, 11:20
... that syntax will only work if you use the dedicated search application 'Everything'.
Thanks Ken. I should've dropped more clues that I was talking about Voidtool's Everything.exe :grin:
Cheers, Chris
There's nothing heavier than an empty water bottle