SuperflyTNT Loc: Manassas VA

You might to get them to sort the way you want.

SuperflyTNT Loc: Manassas VA

The sorting issue isn’t in LR. It’s with the exported JPEG’s.

SuperflyTNT Loc: Manassas VA

Aye! There’s the rub. It’s not about how Lightroom sorts them, it’s how whatever display software he uses sees them. Does it use the current sort from the folder or does it sort by some internal criteria.

DirtFarmer Loc: Escaped from the NYC area, back to MA

There are several things in play here. First of all, looking at the list of files in a folder, they will be ordered by some characteristic of the file. The OS can order the files by file name or by creation date. If you can place the capture date and time in the file name, that is one way to ensure that they will show in chronological order.

Note that the creation date in the metadata can be changed. If one file is out of order you can change the metadata creation date to place it in the desired order.

Lightroom can show you the files in order of creation date, but that will not change how your OS will display the files.

Changing the file name can be tedious if you have a lot of files. However there is software available that can do that for you. There are real advantages to changing the name of your image file so it tells you something about the image rather than using the meaningless camera file name. I use Downloader Pro to rename files, but that software is Windows only. Not supported on MacOS. Downloader Pro can read your file from a card and change the name and write it to a folder (but the name on the card is unchanged). Downloader Pro can also define the folder name where it will place the renamed files.

Note also that Lightroom can rename your files on download and place them in a folder of your choice. You can use the date and time in the file name which will allow your computer OS to sort the files chronologically. Both Lightroom and Downloader Pro use the creation date from the EXIF data to define the date and time. I would expect that since Downloader Pro has been around for a while, there are probably other programs that will do the renaming also. One limitation of Lightroom is that it only has 1 second granularity in the definition of the time. Downloader Pro can use 0.01 second granularity, so you can separate the images in a fast burst.

If you are depending on the file name to define the chronology by date and time, the date should be written YYYYMMDD. That will sort numerically and chronologically the same. Of course if you are using several different sources, they should be synchronized before the shoot. It is possible to do it afterwards but really awkward, and depends on knowing just how far off the sources are from each other, and in what direction.

jbk224 Loc: Long Island, NY

Everyone who has posted has provided valuable information. All good for how each of us does things.
OP has 1 Nikon, 1 Sony, and 1 iPhone, and wants to combine them all and view them in order of date and time.
Forget what any of us do with our workflow. It doesn't really help the OP.
First and foremost, even in a perfect world where his cameras are all properly synced to time-the OP still needs to export all photos to ONE FORMAT. They can rename and edit all they want, but Nikon's NEF, iPhone's HEIC, and Sony's ARW will all sort first by their file type, and by date/time by file type.
This doesn't help the OP view all their photos in time captured sequential order.
So, those of you who do have LR, can you specifically address how the OP can put everything into one folder for his trip and view all photos taken in the order requested?

SuperflyTNT Loc: Manassas VA

Well there’s no viewer he’s gonna use to display these photos in their raw state. He’s gonna have to export first. And when he exports they will all be the same format, unless for some crazy reason he chooses different file types on export.

jbk224 Loc: Long Island, NY

I agree. Let's start the workflow chart: (This presumes no RAW editing)
1. Export all the photos in one format (likely .jpg) with EXIF information intact--into one folder with 'Trip' ID.
2.

cahale Loc: San Angelo, TX

I don't pay any attention to how an editing program may arrange photos. I have mine arranged in folders according to subject/place/date. Then I go to that folder when I want to work on something. Clicking on the one I want to work on brings it up in the default program I usually use. If I want to use another program, I right click and go to "Open With" and select from there. No time wasted or memory (mine) confused.

Jack 13088 Loc: Central NY

You say you use LR6.14 and no manner how you selected the keepers and maybe added them to a collection the Library module can display them by date shot. I have been using LrC by whatever name since Lr3.0 and that was always the case. I left LR6.14 in the dust bin so I can’t verify that now. I have always defaulted to that order except when bewildered by an errant keystroke so I don’t remember exactly how to set it but it is there. Also I believe Windows Explorer can order known image files by date shot and I bet Apple Finder also. Be sure you do not confuse the time the file was created or modified with time shot they are different.

DirtFarmer Loc: Escaped from the NYC area, back to MA

1. Export all the photos through an app that changes the name to include date and time into one folder with a meaningful name for both the image files and the folder name.
2. The OS will then see all the photos in chronological order. As long as all the cameras had been synchronized, the names will be chronological no matter how many cameras you used.
3. Triage, cull, postprocess to taste, export to a different folder (to avoid overwriting the originals).

(this workflow is independent of raw/jpg editing).

jbk224 Loc: Long Island, NY

That's the ticket! OP uses LR. Just import all originals into LR; select all, and export as above with name into the folder name. Et Voila@!
Now let's see if the OP actually does this? Can't wait.

Real Nikon Lover Loc: Simi Valley, CA

I guess I am old skool.

I shoot both raw and jpg. I create a folder for the shoot by name and date of event(s) i.e. Smith Wedding 4-01-2024. That top folder is for post processed photos. 2 subfolders for jpgs and raws. In windows I sort the jpgs and raws by "DATE" in Windows File Explorer, and view by "LARGE ICON". I usually review jpgs as they open quicker due to size. From the jpgs I pick the best of the best and pull up their counter parts in raw and copy (not move) those and paste into the post processed folder. Those become my working files for post processing into my various graphics apps.

Some may feel that this is too labor intensive but I have done this for over 25 years and it has never created a problem for me. For security I always copy the jpgs and raw files to backup drives before I ever start post processing in case I suffer a hard drive failure which has only happened once in 25 years (due to a brown power incident caused by a storm... yes I bought a UPS after that).

DWU2 Loc: Phoenix Arizona area

If you've been shooting in RAW format and are using LR 6.14, there's no way your RAW files will be viewable. 6.14 is over6 years old. Time to upgrade to LR Classic. Then all files will be viewable and sortable. And, for your 10 bucks/month, you'll also get full Photoshop.

AzPicLady Loc: Behind the camera!

I don't do it in LR. LR doesn't matter. In his folder to which he exported all files, he can sort by date. The format doesn't matter. Assumedly he exported all of them in jpeg, but it doesn't really matter if he sorts by date and his cameras are basically synced.

AzPicLady Loc: Behind the camera!

My 6.14 sees my RAW files.