Lightroom: XMP:MetadataDate has wrong time zone

When LR 3.4 writes metadata, it is writing the wrong time zone into XMP:MetadataDate, using a "+" rather than a "-". For example, I'm in PDT (UTC-7:00), but LR writes the following value:

2011:05:13 09:10:17.082+07:00

A number of others have noticed this and wondered whether it has anything to do with LR's problems in spurious "Metadata needs to be updated" notifications; for example, see:

http://forums.adobe.com/thread/849347

A sample image:

3 people have
this problem
+1
Reply
  • Hi John,

    Could you provide some information regarding specifically what your steps are in Lightroom? In the simple case at least, I don't see this problem. Here's what I'm doing:

    1. Verify that my system timezone is set to PDT (UTC -7:00).
    2. Import a JPEG into Lightroom. The DateTimeOriginal (Exif tag #36867) is "2011:05:09 09:07:35?00?"
    3. Select the imported JPEG in the Library in Lightroom and choose Metadata>Save Metadata to File.
    4. Examine the metadata in the file using a tool such as Exiftool.

    Result: xmp:MetadataDate = "2011-05-13T16:48:40-07:00" This is what I would expect. Perhaps there are other operations that are necessary in order to make the bug manifest?

    Thanks,
    Ben
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • Ben, perhaps start with an EXIF timestamp that has no timezone? (I'm just guessing, I haven't tried it.)
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated

  • To the best of my knowledge, EXIF timestamps never contain timezone info. I'm not positive that's true, I'm basing that statement on the Metadata Working Group spec which says, "Exif date/time values such as DateTimeOriginal do not contain time zone information."

    Regardless, the EXIF timestamp in the file I used in my test had no timezone.

    -Ben
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • The EXIF spec doesn't allow for timezones, but I've seen some files that have them stuffed in anyway. Your notes above say "The DateTimeOriginal is ..." with some stuff that doesn't map to ASCII properly but appears to be long enough to include a timezone, which is what made me think of it.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated

  • No, that is literally what it says in the metadata of my file (two zeros inside two question marks). I think that's (blank) sub-second info, but I'm not positive.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated

  • Here's how I've replicated the problem:

    1. Configuration: LR 3.4, Windows 7 Professional 64-bit

    2. Verify clock set to UTC-8 (see screenshot below).

    3. Make a new catalog.

    4. Remove all metadata from p.jpg (attached below) with:

    exiftool -all:all= p.jpg

    5. Import p.jpg.

    6. Add a caption in the Metadata pane.

    7. Metadata > Save Metadata To File

    8. Examine the metadata with Photoshop Elements 8 File > Info, and on the Advanced tab see xmp:MetadataDate containing a "+7:00" rather than "-7:00":

    2011-05-14T07:30:44.017+07:00

    8. Examine the metadata with exiftool and observe that XMP:MetadataDate has a "+7:00" rather than "-7:00":

    C:\Users\Ellis\Desktop\test pics>exiftool -a -G -s p.jpg
    [ExifTool] ExifToolVersion : 8.25
    [File] FileName : p.jpg
    [File] Directory : .
    [File] FileSize : 987 kB
    [File] FileModifyDate : 2011:05:14 07:30:44-07:00
    [File] FilePermissions : rw-rw-rw-
    [File] FileType : JPEG
    [File] MIMEType : image/jpeg
    [File] ExifByteOrder : Big-endian (Motorola, MM)
    [File] CurrentIPTCDigest : 08e4c683387bba4d1884d4f0729495
    c1
    [File] ImageWidth : 2560
    [File] ImageHeight : 1920
    [File] EncodingProcess : Baseline DCT, Huffman coding
    [File] BitsPerSample : 8
    [File] ColorComponents : 3
    [File] YCbCrSubSampling : YCbCr4:2:2 (2 1)
    [EXIF] ImageDescription : Caption for p.jpg
    [EXIF] Orientation : Horizontal (normal)
    [EXIF] ExifVersion : 0221
    [XMP] XMPToolkit : Adobe XMP Core 5.2-c004 1.1368
    81, 2010/06/10-18:11:35
    [XMP] MetadataDate : 2011:05:14 07:30:44.017+07:00
    [XMP] RawFileName : p.jpg
    [XMP] Description : Caption for p.jpg
    [IPTC] CodedCharacterSet : UTF8
    [IPTC] ApplicationRecordVersion : 4
    [IPTC] Caption-Abstract : Caption for p.jpg
    [Photoshop] IPTCDigest : 08e4c683387bba4d1884d4f0729495
    c1
    [Composite] ImageSize : 2560x1920

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited

  • I have reproduced and logged this bug. The wrong sign is used for the UTC offset. In my investigation so far, it only affects the MetadataDate tag, and only occurs on Windows, not Mac, and only in Lightroom and not in other Photoshop Family products.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • I’m FRUSTRATED
    Problem importing photos to Lightroom from Canon 5D Mark 11 (plus Mark 1). Lightroom imports with tomorrow's date, cameras are set correctly as is PC. Disqualified from competitions because of this (photos appeared to be shot after closing date) . Please help.

    This reply was created from a merged topic originally titled
    Lightroom 3 always imports photos to date a day ahead.
    • view 1 more comment
    • Rosalie,

      If you include an original image that shows this problem, some of us might be able to help troubleshoot the problem. You can include the image directly using the photo icon at the bottom of the reply box, or you can use a free service like pixentral.com or Dropbox.com.
    • I have discovered that the problem could possibly be related to using a large capacity memory card. Some of the images from a large shoot have the correct date, a portion do not. Several photos were disqualified from a date sensitive competition. Although all the submitted photos were shot on the applicable date, several rogue shots showed the following day's date. Have you heard of this problem in relation perhaps to a memory card? It has been reformatted?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited