File Not Sorting Correctly

[erichaas]

I have my images sorted by Capture Time, but I have one image that sorts incorrectly.  The correct time stamp on the image should be 2017:04:28 17:16:03-04:00, and this is what shows in the Metadata Panel for both DateDigitized and DateCreated. However, the image sorts as if the time stamp were 2017:04:28 16:16:03-04:00 (i.e., set to an hour earlier).

If I run the Metadata Analyst on the image, I note the following:

Database
   XMP Created Date: 2017:04:28 17:16:03-04:00
   XMP Date Subject Created: 2017:04:28 17:16:03-04:00
   IMatch File DateTime: 2017-04-28T16:16:03                              <--- This is wrong.
   XMP-tiff Orientation: Horizontal (normal)
EXIF
   EXIF metadata found.
   DateTimeOriginal: 2017:04:28 17:16:03
   CreateDate: 2017:04:28 17:16:03
   User Comment:
   Lens Model: 8-16mm F4.5-5.6
   Make (IFD0): SONY
   Model (IFD0): SLT-A77V
   Image Description (IFD0):
   Orientation (IFD0): Horizontal (normal)
   Orientation (IFD1): Horizontal (normal)
   XMP-tiff Orientation in Database: Horizontal (normal)
Legacy IPTC
Legacy IPTC metadata found.
   Created timestamp: 2017:04:28 17:16:03-04:00
   DigitalCreation timestamp: 2017:04:28 17:16:03-04:00
   Character Set Encoding: unspecified.


Any ideas how to fix this?

[Mario]

Your file has various timestamps in various time-zones, this is always tricky. Your local time-zone, at the time of import, will also impact this. Including daylight saving time which may or may have not been in effect at the time!
Did your file have XMP metadata when it was first added to IMatch? If not, IMatch will have had to pick a timestamp, using the rules explained in the help. How IMatch uses Date and Time Information
Did you change the data and time later? Modified the time-zones?
The variable {File.DateTime} in the VarToy app shows the date and time IMatch has chosen. You can affect it by editing "Date Subject Created" in the Metadata Panel.

[erichaas]

Date Subjected Created already has the correct time stamp: 2017:04:28 17:16:03-04:00. If I change it by adding 10 seconds, the IMatch File DateTime changes by 10 seconds as well, but it stays one hour off.

[Mario]

What is your local time-zone? -04:00 UTC?

[erichaas]

Currently -05:00 UTC.

[Mario]

So the file in question is of by one hour, which is the difference between your local time zone and the time zone set for the image.

[erichaas]

Yes. But the other files in the folder are also UTC -4, but are not off by one hour.

[Mario]

How mysterious.

What happens if you write-back the metadata?
And then force an update with Shift+Ctrl+F5? If this persists, send me the file and I will tell you why IMatch behaves how it does.

[erichaas]

Sorry, I didn't answer your other questions. The file did not have XMP metadata when it was added to IMatch. It also did not have time zone information when it was added to IMatch, I added that later. In fact, I added time zone information to all of the images in that folder at the same time.

[Mario]

If you can reproduce this behavior after writing back the data to the file and re-importing it, send it to me. I should then be able to reproduce this as well.
Note that File.DateTime is in local time, so your local time-zone and the time-zone offset added to the file and the daylight saving time at the time the file was added is relevant.

[erichaas]

I emailed you a link to the file in question.

[erichaas]

As an experiment, I took an image that was sorting correctly, used shift+ctrl+F5 and selected Force Update. That image now sorts out of order, as if it's time stamp were one hour earlier than it actually is.

Database
XMP Created Date: 2017:04:28 16:52:36-04:00
XMP Date Subject Created: 2017:04:28 16:52:36-04:00
IMatch File DateTime: 2017-04-28T15:52:36
XMP-tiff Orientation: Horizontal (normal)

[mastodon]

I have something like this, but now I am too lasy to dig it out. It seems to me, that is is related with timezones.

[Mario]

I emailed you a link to the file in question.

I did not receive an email from you. Maybe it was SPAM filtered or something?

[Mario]

See support email address

[Mario]

I have no received your two sample files, thank you.

The file without a problem has the XMP timestamp
2017:04:28 16:52:36-04:00 and IMatch sets File.DateTime to 28.04.2017 21:52:36
which is correct for my local time zone 05:00 hours difference.

The file which causes the problem on your system has the XMP timestamp
2017:04:28 17:16:03-04:00 and IMatch sets File.DateTime to 28.04.2017 22:16:03
which is also correct for my local time zone.

The time is shifted by 5 hours for each file when setting the File.DateTime. Since this is the date and time used for the default "Created" sort profile, the files should sort correctly.
I've tried the "Capture Time" and "Capture Time (Created First)" and they sort the files correctly.

1.  Do you get the same results as I get?
You can use these variables in the VarToy App for a quick check:

{File.MD.XMP::photoshop\DateCreated\DateCreated\0|value:formatted}
{File.DateTime}

2. Do you see a change when you select both files and press Shift+Ctrl+F5 and then select "Reload Metadata"?

3.  Do you have the option Apply time-zone enabled under Edit > Preferences > Metadata 2? (This is the default).

[erichaas]

1.  Do you get the same results as I get?

No. One file gives me

2017:04:28 17:16:03-04:00
4/28/2017 4:16:03 PM

and the other

2017:04:28 16:52:36-04:00
4/28/2017 4:52:36 PM

2. Do you see a change when you select both files and press Shift+Ctrl+F5 and then select "Reload Metadata"?

Yes. The first file remains the same, and the second file changes to

2017:04:28 16:52:36-04:00
4/28/2017 3:52:36 PM

So, it would appear that the first file, the one I thought was the problem, was actually okay, and the rest of the set needs to have its metadata reloaded.

3.  Do you have the option Apply time-zone enabled under Edit > Preferences > Metadata 2? (This is the default).

Yes.

[Mario]

As I said above, File.DateTime is in local time.
The timestamp is set when you add the file to the database, later update it or if you change the date and time in the MD panel or otherwise.
If or not daylight saving time is active at the time matters.