Windows adds to the confusion after you've copied your image or video files from the camera by appending several dates to each file.
Looking a a random JPG file using Properties in Windows 10 File Explorer I see:
Date Created: 21 November 2024, 13:11:25
Date Modified: 20 September 2024, 17:01:21
Date Accessed: 28 January 2025, 14:18:12
Somewhat bizarrely:-
Created shows the date when I copied the JPG file from my SD or CF card to my hard disk
Modified shows the time stamp and date recorded by the camera when I took the photo
Accessed is today's date and time when I selected Properties for the file
When I add more columns in File Explorer (right click top line) I get three columns, Date Created, Date Modified and Date Taken, but now Date Modified is exactly one hour later than Date Taken, presumably due to a Daylight Saving Time setting on camera being one hour different from the computer time or UTC? It's all very confusing to a bear with no brain.
Would it be possible after a long automatic sorting by date of these photos for the indexing service to remember how these photos are sorted so that after restarting the system, after opening the folder, these photos are sorted.
I suspect you (we) need some kind of dedicated photo library indexing software. I know someone who religiously enters every photograph taken into a very old version of Adobe Lightroom, then adds descriptive text detailing the subject matter. I suspect that Lightroom has the ability to sort by date taken. A trivial task for a database. The problem is, you can no longer buy a stand alone copy of Lightroom, but instead Adobe charge a monthly subscription.
Instead, consider Adobe Bridge. This software is free, but you do have to sign up for a (free) Adobe account. They will then try to persuade you into buying a subscription for Photoshop, Lightroom, Premiere Pro, et al, but you can ignore these requests.
https://fixthephoto.com/best-free-photo-organizing-software.html
https://www.adobe.com/uk/products/bridge.html
If you have a Canon, Nikon, Fuji, Sony camera, why not download their own software package? They're similar to Bridge/Lightroom/Photoshop, but not as sophisticated.
The file names are mixed up because the camera numbers the photos from one every now and then and there are photos from different cameras that start numbering photos from numbers and others from letters, so I can't use file names.
I have the same problem wielding 3 DSLR bodies. When the frame counters reach 9999, they revert to 0000 and start incrementing the count. On a busy vacation, I can end up with several batches of files with identical file names, but different dates taken.
My solution regarding camera identification is to edit the 3-character prefix for each body making it unique, so I know which body the files come from. I backup the RAW + JPG files each evening into folders on my laptops, with the date and camera name. 3 cameras, 3 folders, per day. Not perfect but it narrows things down when seaching, unless I've taken 1000+ frames in one day.
I have to wait a very few minutes. Especially when the disk is a platter disk.
Exactly the same problem here. It can take Windows minutes to catalogue a folder with thousands of RAW files. I've not found a solution yet, but I haven't looked too hard. Even indexing an M.2 NVME drive is slow.