MP4 created date Google Photos vs Lightroom

[MEH_PDX]

Can I fix this problem? I am trying to get Google and Lightroom to sort my photos correctly.

I took a video with my Panasonic Lumix at 19:18 this evening. I am -7UTC Pacific Time
I uploaded the Lumix MP4 to Google Photos but the time is incorrectly interpreted as 12:18.
I loaded the Lumix MP4 into Adobe Lightroom and the "capture time" shows correctly as 19:18.

I took another video with my Nexus 6P cellphone at 19:10 this evening.
I uploaded the 6P MP4 to Google Photos and the time shows correctly as 19:10.
I loaded the 6P MP4 into Adobe Lightroom and the "capture time" shows incorrectly as 02:10 the next day.

It would appear the Lightroom and Google handle the timezone offset differently but I don't know what to change to bring them into sync.

Thanks for any input,
Mike

[StarGeek]

To be honest, you're going to have to choose whether you want Google or Lightroom to sort correctly, because they're not compatible in the way they're doing it.

The first problem is that Google is ignoring the time zone offset.  The second problem is that the Nexus 6P is incorrectly writing the timestamp.

Odds are the tags that are being read are in the Quicktime group (see Quicktime tags).  Timestamps in this group, by the specs, are supposed to be written in UTC.  Unfortunately, a lot of cameras write local time instead.

It's up to you to decide which is the best way to go about it.  Which are you going to rely on more, Google or LR?

Exiftool can write to some of the Quicktime timestamps (MediaCreateDate, MediaModifyDate, TrackCreateDate, TrackModifyDate, CreateDate, ModifyDate, and PreviewDate) but not to CreationDate or DateTimeOriginal.  I believe CreationDate is often given priority by various programs, though I haven't tested it extensively.

[MEH_PDX]

Thanks for the feedback.
I was afraid that there was no easy answer. Since I don't have much control over the way Google handles the date/time, I guess I'll focus on Lr.
So, I "corrected" the createdate by shifting it -7 .
Now Lr shows the default "Capture Time" and "Capture Date" as 19:10:28 - Oct 19, 2017.  correct
And Lr also shows EXIF "Date Time Digitized" as 10/19/2017  19:10:28.  correct

Perhaps Google, Adobe and all the other interested parties will shake hands and standardized this mess.
No, probably not. 

[StarGeek]

I think that since Adobe caters to a more professional clientele, they're a bit more likely to keep to the specs (though I'll be Phil has something to say about that).  Google, on the other hand, is dealing with the general population, who just wants it to work.   

[MEH_PDX]

OK, so I'm thinking maybe I should try writing the CreateDate to the filename and then sort by filename in Lr.
But I run into trouble...
I have a directory called Pano with 2 files P.jpg and P.mp4 and I run a Windows batch file containing this line...

exiftool -k "-FileName<CreateDate" -d %Y%m%d_%H%M%S%%-c.%%e P.mp4

But the output reads:
D:\Mike\Pictures\test\Pano>exiftool -k "-FileName<CreateDate" -d mHS%-c.%e P.mp4
    0 image files updated
    1 image files unchanged
-- press RETURN --

Typical newby mistake, I suppose? Can you help?

[StarGeek]

Double all % in a bat file.

[MEH_PDX]

Ah yes, if I would have just read the documentation a bit closer....

Notes:
1) In a Windows BAT file the "%" character is represented by "%%",
so an argument like "%d%f.txt" is written as "%%d%%f.txt".

Thanks for sticking with me, StarGeek.

[StarGeek]

Ah yes, if I would have just read the documentation a bit closer....

Or the .sig at the bottom of all my posts