Lightroom: Still inconsistent capture date/time for photos and videos

  • 55
  • Problem
  • Updated 1 month ago
  • Acknowledged
  • (Edited)
Update 5/17/2018: Though LR 7.1 made improvements, LR 7.3.1 still has two closely related problems with a single underlying cause:

- With photos and videos missing metadata capture date/times (e.g. scans), there is still an inconsistency between the times shown under the thumbnails in grid view and in the Metadata panel and the hidden, internal times used for sorting in grid view.

- Changing IPTC Date Created in the Metadata panel, either by editing the field or using Metadata > Copy/Paste Metadata, similarly causes inconsistent values to be shown and sorting and searching to work inconsistently.  It also causes date metadata to be written back to the files that doesn't conform with the Metadata Working Group's standard.

The underlying cause is architectural: LR doesn't have a single internal catalog field representing "capture time".  Rather, it maintains capture time in several different fields, and the various parts of LR update those fields inconsistently.

See here for precise recipes to replicate these bugs:

https://feedback.photoshop.com/photoshop_family/topics/lightroom-still-inconsistent-capture-date-tim...

https://feedback.photoshop.com/photoshop_family/topics/lightroom-still-inconsistent-capture-date-tim...

See here for a workaround: 

https://feedback.photoshop.com/photoshop_family/topics/lightroom-still-inconsistent-capture-date-time-for-videos?topic-reply-list%5Bsettings%5D%5Bfilter_by%5D=all&topic-reply-list%5Bsettings%5D%5Breply_id%5D=15475521#reply_15475521.  

-------------

LR 5.7 still shows inconsistent capture date/times for videos. For a test .avi on Windows 8.1, the date in grid view appears to be the file system's last-modified time, while Capture Date/Time is set to the time of import.This problem was declared fixed in LR 5.5, and it appears to have been fixed for images, but not videos:http://feedback.photoshop.com/photoshop_family/topics/inconsistent_dates_for_files_missing_date_time...I'm opening a new topic, since the previous one has been marked "Solved".
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes

Posted 5 years ago

  • 55
Photo of Tir

Tir

  • 1 Post
  • 0 Reply Likes
Yes, this is quite annoying for me. Because reverse capture date is my preferred sorting method in the grid, old videos I add are being shown before anything else, because LR5.7 is putting their capture date as the time of import.

Here's a much less neater example than above (scribbled on my Surface):

Photo of Daniel Arbeeny

Daniel Arbeeny

  • 46 Posts
  • 0 Reply Likes
I find the behavior has changed BUT is still wrong.
Photo of HHHeflin

HHHeflin

  • 15 Posts
  • 0 Reply Likes
Thanks for keeping this issue "Open".
Photo of fotografista.net

fotografista.net

  • 5 Posts
  • 1 Reply Like
I imported >1000 videos from 2014, all got the "Creation date" set to "Import date" (for all my video-sources), although they could be split into the proper folders by date during the import, which means LR *CAN* properly interpret the dates, *BUT NOT* in the Library while sorting!

This is total disaster, because I am not able get the files in the correct creation order to rename and store them properly, which *CRUCIAL* to work with the video clips!

There is a *WORKAROUND*: you can make LR update the dates using the menu function "Metadata/Edit capture time".

... *BUT* - I am not going to do it manually for 1000 files. And after that *FOR EACH AND EVERY IMPORT*...

This seams to be a simple *BUG* and I do not understand why it has not been fixed for years now as it is a *FUNDAMENTAL FUNCTIONALITY*.

I would really appreciate to get a fix *SOON*. Or at least a better workaround. At the moment I'm *BLOCKED* in my workflow, and the material get produced more and more.

I can support the developers with further details and examples.
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes
Fotografista wrote: "There is a workaround: you can make LR update the dates using the menu function 'Metadata/Edit capture time'. ... I am not going to do it manually for 1000 files."

I haven't tried it recently, but in the past you could select all the videos, do Metadata > Edit Capture Time, and then hit OK without making any changes to the date/time. This would set the capture time correctly for each of the selected photos. So you wouldn't need to do it one video at a time.
Photo of fotografista.net

fotografista.net

  • 5 Posts
  • 1 Reply Like
John,

that would work. But *all* the files would get then the *same* date and time (of the "most marked" one). It's OK, if you wanted to move the time of all files about an interval, but that is not what I need.
Photo of fotografista.net

fotografista.net

  • 5 Posts
  • 1 Reply Like
I saw there hundreds of bug reports in here...

I would really appreciate to get an answer it was read from someone from LR Team. Just to know this thread in not an dead end...
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes
Fotografista wrote, "But *all* the files would get then the *same* date and time (of the "most marked" one)."

I haven't tested with videos in the most recent version of LR, but in previous versions, I and others observed that Edit Capture Time would set the capture time of each video to its correct internal time, not the time of the most-selected video.

That in general is how Edit Capture Time works when you have multiple images selected. It offsets each image's time by the amount that the most-selected image is being offset. If the most-selected image is being offset by 0 seconds, than all the others will be too:



The text of the Edit Capture Time window says "but not videos", but at least in past versions, it did what I described. Worth a test.
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes
Update: I just updated my post to clarify a little.
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes
I just verified with LR 5.7.1 / Windows 8.1: You can correct the inconsistency described in the original post above by:

1. Select all the videos.

2. Metadata > Edit Capture Time

3. OK

For each video, this will make the Capture Date/Time shown in Metadata panel match the capture date/time shown under the thumbnail in Library Grid view (which is the file's last modified time, if LR wasn't able to read the file's metadata).

There is no need to do each video one at a time. But if you have any doubt, make a backup of your catalog first.
Photo of tale

tale

  • 11 Posts
  • 3 Reply Likes
Had some issues when attempting to assign the capture date/time of a video to its filename. There was always a strange offset.

I tried this workaround before renaming and it then worked fine.

Always worth a shot, I guess.
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes
"Had some issues when attempting to assign the capture date/time of a video to its filename. There was always a strange offset."

If they were Quicktime videos (e.g. with extension .mov, from an iDevice), there's a known bug where LR gets confused by the time zone (or lack of one) stored in the video's metadata: http://feedback.photoshop.com/photosh...
Photo of tale

tale

  • 11 Posts
  • 3 Reply Likes
Sorry, haven't been here for a while. Dropped by to thank you for suggestion.

Timezone handling seems to be kind of funny indeed, even with images.
Example: it  seems that any timezone stored in a picture (e.g. by Geosetter) will be removed when re-saving new meta information within Lightroom.

Then again... I'm not completely sure about the standardized process, so maybe it's some sort of irregular information anyway.
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes
"it  seems that any timezone stored in a picture (e.g. by Geosetter) will be removed when re-saving new meta information within Lightroom."

Yeah, LR doesn't follow the standard (Metadata Working Group, of which Adobe is a member), which calls for existing time zones in date/times to be preserved.   LR is pretty aggressive at pretending time zones don't exist.
Photo of Bruce Lull

Bruce Lull

  • 3 Posts
  • 0 Reply Likes
This technique seemed to work more generally. I used it to fix both video and .JPG's that were sorting incorrectly. This was with Lightroom CC on a Mac. Thanks a bunch!
Photo of 570E

570E

  • 4 Posts
  • 1 Reply Like
Hi John. Would you please take a minute to explain the three steps above in a little more detail? 
1. Select all the videos. In LR, correct?  
2. Metadata > Edit Capture Time- I see: Adjust to a specific time and date, Shift by a set number of hours and Change to a file's creation date (does is not the correct creation date) - Which of these options do I select?
3. OK 
Thanks in advance. 
LR6/Win7
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes
Select multiple videos or photos, choose "Adjust to a specified date and time" (the default), then click "Change All".
Photo of 570E

570E

  • 4 Posts
  • 1 Reply Like
Thank you again John. You're the best!
Photo of 570E

570E

  • 4 Posts
  • 1 Reply Like
Actually one more question John. I did what you suggested and everything seemed to work well. While my files were being corrected for date and time I deleted a picture I did not want. I removed it from disk. Since all files were selected, that deleted all of my pictures and videos. They were in my Win 7 recycle bin and I was able to restore them to the correct folder in my HD. My last catalog backup was 6 weeks ago. Is there anything I can do to recover my edits or did I lose all the work I did this past month and a half?
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes
Do you have regularly scheduled system backups made by a backup utility?  If so, you could try recovering a more recent catalog from there.

If you had checked the option Catalog Settings > Metadata > Automatically Write Changes  Into XMP, then your develop edits and metadata changes will be stored inside of non-raw files (e.g. JPEGs) and in .xmp sidecars for raw files, and you could recover the changes.

But if you don't have a more recent backup of the catalog, and you didn't have that option checked, I'm afraid you're out of luck.  

Going forward, I highly recommend you select that option, since it provides a second level of protection for precisely these kinds of situations.
Photo of fotografista.net

fotografista.net

  • 5 Posts
  • 1 Reply Like
To John:

thank you very much for all your research, I'll give it a try, although it seems to be just another workaround and it MAY stop working for any reason...

I've just gone through my 1000 thousand videos and stated the problem is even worse - there are sources (android devices only?) where there is the original capture time wrong - it can be seen under windows as well (last modification time). It seems to be a creation time while copying the files on android or something like that. Now I am completely unsure if there is anywhere the proper capture time - as I said windows shows not the expected time and LR shows just nothing...

I will probably need to dig in the EXIFs of the videos... I hoped LR is clever enough to manage it on its own. I'm getting even more frustrating. I am ensuring myself one again - NEVER EVER TRUST any tools you didn't constructed yourself...

... my origin idea was so simple - throw everything into LR, let it sort by LR and make your own order. None of these works 100% (just try to import some BMPs from a scanner).

Grrrrr
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes
LR does a poor job with video metadata in general. Add your vote and opinion to this topic:

http://feedback.photoshop.com/photosh...

You might consider my Any File plugin to manage your videos in LR. It uses the very robust Exiftool to extract video metadata and add it to the LR catalog, and any changes you make to the metadata in LR get written back to JPEG sidecars. Any File isn't as convenient as having proper video management built in to LR, but it gets the job done reliably.
Photo of Daniel Arbeeny

Daniel Arbeeny

  • 46 Posts
  • 0 Reply Likes
I believe that Any File plugin is great, thanks John!

Does anyone know if this has gotten better in LR6?
Photo of Louis Sherwin

Louis Sherwin

  • 146 Posts
  • 32 Reply Likes
I havn't tried it yet but there is nothing in the release notes that indicate that anything was done to improve metadata for video or image files.
Photo of John Ellis

John Ellis

  • 117 Posts
  • 12 Reply Likes
The bug still exists in LR CC 2015.0.1 / Windows 8.1.
Photo of Peter Roman

Peter Roman

  • 1 Post
  • 0 Reply Likes
This is absolutely maddening, especially as I'm trying to migrate from Aperture which can read all the date, camera, and location info on videos just fine (and has for years).

The data is all there, can be read by other competing apps along with utilities like exiftool. Why can't Lightroom do the same?
Photo of Steve Dempsey

Steve Dempsey

  • 1 Post
  • 0 Reply Likes
The bug still exists in LR CC 2015.1 released a couple of days ago. Given that this bug has been present in some form for 4 years now without a resolution is a deal-breaker for me in my quest to find an Aperture replacement.
Photo of raz

raz

  • 1 Post
  • 0 Reply Likes
Not sure why is rocket science for Adobe to acknowledge and fix such an obvious bug. The whole video support is just poorly made
Photo of Suzanne Levine

Suzanne Levine

  • 1 Post
  • 0 Reply Likes
I'm having a similar problem. The dates are correct on my Samsung video camera and files, but when LR imports them, it says they were shot in 1949 (and bizarrely, a day before the actual day they were shot)! I can go into each folder and "Edit capture time" and select "Date file created" to fix the dates, but then I have to drag and drop each file into the correct date folder, because LR sorted them all (upon import) into folders with the wrong dates!
Photo of Mitch Enzmann

Mitch Enzmann

  • 2 Posts
  • 0 Reply Likes
This reply was created from a merged topic originally titled Sorting by date issues with .mts and .mov files.

The Meta Data of the files look correct, but the sorting is wrong (maybe some creation date problems)

I'm a Mac User on Mac OSX 10.10.4
(you forgot to add a specification on this form!)
Photo of fotografista.net

fotografista.net

  • 5 Posts
  • 1 Reply Like
After months of waiting if not for a solution that at least for a reaction from Adobe I decided NOT TO USE LR for any video-oriented purposes, it seems the video features are pure marketing, sadly.
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes
This bug also happens for photos when there is no DateTimeOriginal but there is an EXIF:ModifyDate, e.g. with a scan that's been edited by an app but doesn't have a capture date.

As an example, here are the relevant metadata date fields for a sample TIF:


$ exiftool -a -G sample.tif | grep -i date
[File] File Modification Date/Time : 2015:08:22 12:25:20-07:00
[File] File Access Date/Time : 2015:08:22 12:25:22-07:00
[File] File Inode Change Date/Time : 2015:08:22 12:25:20-07:00
[EXIF] Modify Date : 2015:08:21 21:02:27
[ICC_Profile] Profile Date Time : 1998:02:09 06:49:00


And here's a screen shot showing that the date under the thumbnail shows the operating system's file modified date, while the Metadata panel shows the capture time as the EXIF:ModifyDate:
Photo of Daniel Caldwell

Daniel Caldwell

  • 1 Post
  • 1 Reply Like
I have this problem too. My photo was taken on my iphone using a different app and the photo didn't record an Exif capture time. However, it must detect it somehow as the capture time is correct in the metadata tab. The end result is that even though the capture time is correct, it doesn't sort by capture time correctly. The photos that reproduce this are here:

https://www.dropbox.com/sh/vmanuyx80y...

There, the middle photo doesn't sort correctly even though the metadata shown in the metadata tab looks correct.

My light room version is 5.7.1 build number 994254
Photo of John R. Ellis

John R. Ellis, Champion

  • 4390 Posts
  • 1166 Reply Likes
Another inconsistency (observed in LR CC 2015.3) for photos missing a capture date in their metadata: The metadata panel shows a capture date, but the Date column for the filter bar shows "Unknown".

Photo of Pavlos Honderich

Pavlos Honderich

  • 4 Posts
  • 0 Reply Likes
This reply was created from a merged topic originally titled Lightroom 5.7 Rename feature applying incorrect Capture time when Renaming video ....

The rename functionality within Lightroom 5.7 ( “Menu>Library>Rename Photo”) is broken when renaming video files using filename templates that contain the “Date” tags. This is only an issue with rename as the problem doesn’t occur during the initial import of the video files into the catalog using the exact same template. The problem appears to only affect video files and not my RAW or JPEG files.

My filename template contains a “Custom Text” tag followed by the capture date. For example:
5diii.November 21, 2015-18.05.35.MOV

Rather than use the capture time the bug in the rename functionality pushes the file’s name 6 hours into the future. This is what led me to uncover the problem as a directory from 21st of the month contained files named as if they’d been shot on the 22nd...

As noted the initial import works just fine so as a test I removed one of the affected video file from my library, moved it to another part of the disk, and then re-import the file. Upon doing this the file’s name correctly reflected the capture time. (Note I had to move the file because the import dialog hides the rename option if the file is in the same path it’s going to be imported into – could be annoying for some).

See the included screen captures for details of what I've said here.

While the above workaround is a viable it’s a very painful one as my custom tag is based on my camera model. To preserve that I had to isolate all my video files by model and re-import each separately applying the correct custom tag to my template. Under Windows 10 this isn’t too big a deal using both search and copy, but it still took a good hour and was only made easier by the fact that, unlike my still images, all my video images are in a single catalog. That said the catalog spans 10 years and includes ~2500 files. In that time my wife and I have used 7 different cameras and 5 different smartphones which is what made it a pain.

I happen to in UTC-6, but changing my timezone on my PC doesn’t seem to affect the problem and even then I’d expect the value to be 6 hours in the past and not 6 hours in the future - unless an absolute value is being applied. That said I have no idea if LR is determining my time zone from my IP address and not looking at the system time but I’d be surprised if that were the case so this is probably just a coincidence.

Finally, I’ve only had to rename files in my video catalog if I forgot to set the “Custom Text” for the camera model. Not doing so defaults the custom text to ‘untitled’. It would be nice if LR threw an warning if this was the case as I doubt most people intend their file names to contain untitled. IF possible I could see this being an optional setting ("Warn custom tag not specified") stored on the template that is set to true by default, otherwise a global catalog setting would be nice.

On a related note once an instance of LR has been used to perform an import the custom text is retained until LR is restarted. While a nice feature, this has caused me to accidentally apply custom text for the wrong camera if I import from multiple sources in one session and forget to change the custom tag. A similar option warning would be nice (i.e. “Warn custom tag when changing source”)

The video in question as it appears in my catalog alongside file system details from Windows 10:


The video in question re-imported with the correct date along side the incorrectly named one. Note that I brought up the rename dialog on the correctly named file and the preview shows the name reflecting the 6 hour shift:
Photo of John R. Ellis

John R. Ellis, Champion

  • 4279 Posts
  • 1138 Reply Likes
As described in this topic, LR has a number of longstanding inconsistencies when handling video capture dates. Also, it doesn't handle Quicktime (.mov) capture dates very gracefully, which results in a time zone shift: http://feedback.photoshop.com/photosh...
Photo of Pavlos Honderich

Pavlos Honderich

  • 4 Posts
  • 0 Reply Likes
John, is there anyway to find out who merged my topic into this one? My issue is related to the File rename functionality. The capture times I see are correct, it's how they're used that is a problem. (see my general comment below)
Photo of Pavlos Honderich

Pavlos Honderich

  • 4 Posts
  • 0 Reply Likes
I just noticed my topic/bug was merged into this one. I feel this was done in error as my issue is specific to how LR is applying a file rename template. It's possible whoever did this only read my topics title and mistook my issue to be related to this thread.

As noted in my topic and the screenshots I linked, the capture time LR displays is correct. How it uses that time to generate my filename per my rename template is not. If the rename is performed at import it is correct (with the exception of MTS files) but if I apply a rename AFTER the import it shifts all my file names by 6 hours. The capture time remains correct.

To whoever merged my topic please undo this or. I specifically chose not to merge it into this topic as my problem is not the same as that as the OP's. I don't want my information pertaining to the rename functionality to be overlooked as I feel it offers some clues as to where the rename issue resides (i.e. works during import - for at least mov/avi files, fails for MTS - fails on subsequent renames). As a developer myself I know those sorts of clues could be very valuable. It took nearly 2 hours of testing to gather the details in my post and I now its been merged into a mostly unrelated thread where the information may get overlooked (especially given the age of this thread).

As you can see below the file reports a capture time of 6:05 PM. This is the correct capture time (it's dusk outside not midnight). What is incorrect is how LR chose to apply said capture time to the file rename template which generated a time 6 hours in the future. This issue was consistent across my entire catalog and always +6 hours off. As noted my workaround was to re-import my catalog and the problem went away for all but MTS files.


as you can see in the file system details (as posted in my org post) the capt time is correct. my issue is not related to OP; please unmerge