Searching range of dates; a nightmare

Page 1 of 2 12 LastLast

  1. Posts : 322
    win 10 home
       #1

    Searching range of dates; a nightmare


    I am trying to find photos taken between two dates, following various advices. They could be located in more than one position.
    From the forementioned advice I am choosing to insert in the search box
    Code:
    datetaken:dd/mm/yyyy .. dd/mm/yyyy
    . However, even though I know such pictures exist, nothing is found.

    Ideas, please. :)
      My Computer


  2. Posts : 42,963
    Win 10 Pro (22H2) (2nd PC is 22H2)
       #2

    Hi, this works for me, for example:
    Searching range of dates; a nightmare-snap-2019-03-24-15.09.32.png

    Note- date taken must be specified in the field I've highlighted in the Properties sheet.

    Other image files in that test folder have dates in other years.

    This, as specified in Advanced Query Syntax reference doc.
    Advanced Query Syntax - Windows applications | Microsoft Docs
    (which is incomplete and old)
    also works:
    Searching range of dates; a nightmare-snap-2019-03-24-15.17.20.png

    - but note that's date, not datetaken

    This is what you seek:
    Searching range of dates; a nightmare-snap-2019-03-24-15.18.52.png

    It works if, after the first date, you type .. and then with no spaces the 2nd date.

    Curiously, you get a clear prompt and calendar box for the first date, but none for the second.

    In your case you have spaces around the ..

    I also can't tell where your search box is - what it belongs to.
      My Computers


  3. Posts : 456
    Windows 10
       #3

    You can type something like this in the search field:

    Code:
    datemodified:(>YYYY-MM-DD hh:mm .. <YYYY-MM-DD hh:mm)
    YYYY=Year
    MM=Month
    DD=Days
    hh=Hours
    mm=Minutes
    ss=Seconds

    For example to find files modified between 10/03/2019 Hour 15:30 and 17/03/2019 Hour 10:00:

    Code:
    datemodified:(>2019-03-10 15:30 .. <2019-03-17 10:00)
    To find pictures only in that same date range:

    Code:
    datemodified:(>2019-02-10 15:30 .. <2019-03-17 10:00) kind:picture
    Code:
    datemodified:(>2019-02-10 .. <2019-03-17) kind:picture
    * If your Windows is not in English you can change the tags "datemodified" and "Kind" to the equivalent of your Windows language. For me (Portuguese-Brazil) it would be "datademodificação" and "espécie" or you can use the english version but have to add "system." in front of each tag:

    Code:
    system.datemodified:(>2019-03-10 15:30 .. <2019-03-17 10:00) system.kind:picture
    * You don't have to especify the hours
    * Instead of ".." you can also use "AND" between the dates
    * Instead of YYYY-MM-DD hh:mm you can use your local date format ex: DD/MM/YYYY hh:mm:ss


    If you want to make a log with a listing of all files that were created or modified between two dates you can acomplish this with robocopy:

    Let's say you want a log with all the pictures created or modified between the dates of 10/03/2019 and 17/03/2019 in your e: drive and save the log on your desktop:

    1. Open a comand prompt and type something like this:

    Code:
    robocopy E: %temp% /ndl /ts /nc /fp /njh /njs /ns /e /tee /L /maxage:20190310 /minage:20190317 *.jpg *.gif *.png *.bmp /log:%userprofile%\desktop\10-03__17-03.txt
    /ndl -> No Directory Listing
    /ts -> Time stamp
    /nc -> No Classes
    /fp -> Use Full Paths
    /njh -> No Job Header
    /njs -> No Job Summary
    /ns -> No Sizes
    /e -> Includes subfolders including Empty
    /tee -> Shows listing on screen and saves the log
    /L -> Listing only (If you don't use this robocopy will actually copy the files to %temp%
    /maxage -> The maxage that files should have to be included
    /minage -> The minimum age that files should have to be included
    /Log -> The path to the log file
    *.jpg *.gif *.png *.bmp -> restrict the search to this files
      My Computer


  4. Posts : 16,932
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #4

    If you use the File explorer search box you can type in
    Code:
    datetaken:
    and a calendar control appears so you can just select the range of dates you want.

    Searching range of dates; a nightmare-file-explorer-search-box-datetaken.png

    You may notice afterwards that the File explorer enters your selection in the syntax
    Code:
    datetaken:20/03/2019 .. 27/03/2019
    and there is nothing to stop you typing it in that way yourself but using the Calendar control to do this avoids typos.

    Denis
      My Computer


  5. Posts : 41,462
    windows 10 professional version 1607 build 14393.969 64 bit
       #5

    Were all saved as jpg? or were some tif, png or gif?
    Was the date used in the save as?
      My Computer


  6. Posts : 322
    win 10 home
    Thread Starter
       #6

    dalchina
    Thanks for your quick reply. I have had some problems interpreting it, and had thought from other examples spaces were needed before and after the periods, but no matter since I located the ones wanted by doing a simple search between 2 dates.
    @ricardobohner
    Thank you for the info on where to place the kind filter and other info. @Try3.
    How did you select dates? I assume by holding down Control>copy and dragging. What happens if dates run over month ends?
    Once again thanks for all your help. Now it’s time to sort out, which of several versions I want.
      My Computer


  7. Posts : 16,932
    Windows 10 Home x64 Version 22H2 Build 19045.4170
       #7

    How did you select dates? I assume by holding down Control>copy and dragging. What happens if dates run over month ends?
    Just click & hold down as you drag across the desired dates. If you drag over the end of the month you see the next month appear automatically but this happens very quickly and you can easily get yourself three months ahead before you've even blinked.

    Just in case it's needed - it is not a Kind filter. A Kind filter is not the same. Enter Kind: in the File explorer search box and you will see a special dropdown list appear [that might also be useful for other picture searches you might do in the future].

    Denis
      My Computer


  8. Posts : 13,301
    Windows 10 Pro (x64) 21H2 19044.1526
       #8

    there is a indexing program called "everything" that works for me. It takes time to index all files but after you can set search
    parameters just for photos. and get the results in seconds. You can also click on date and reorganize the results.
    You can find it at Ninite.com
      My Computers


  9. Posts : 41,462
    windows 10 professional version 1607 build 14393.969 64 bit
       #9

    thomaseg1, Nice. I planned to suggest the same software and was waiting for a reply to post #5.
      My Computer


  10. Posts : 42,963
    Win 10 Pro (22H2) (2nd PC is 22H2)
       #10

    Can you confirm Everything is able to search on the basis of 'datetaken' metadata- not just date?
      My Computers


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 18:01.
Find Us




Windows 10 Forums