[GIS] Using Field Calculator to Add a Set Amount of Time to Date Field

arcgis-10.0arcgis-desktopdatefield-calculatorgpx

I wish to georeference several photos to a track created using a Garmin Oregon 450t, but the time recorded in the photos and the time recorded in the .GPX are not the same.

The format for the date field is day, month, year, hour, minute, second e.g. 27/05/2014 7:20:05 PM. My (limited) attempts with the Field Calculator so far have yielded nothing.

Is there a simple method to add or subtract something like one hour, five minutes and eighteen seconds to all records in the date field?

Best Answer

Use the DateAdd (or here) function. It looks like hours, minutes and seconds have to be added separately (3 calcs). I recommend adding a new date field and field calculating there... to preserve the original.

enter image description here

Related Question