SharePoint Document Issues

How to Fix SharePoint Photo Date and Time Showing 14 Hours Ahead

Amos Gikunda Oct 22, 2026 868 views

Question details

Users need a solution for photos uploaded to SharePoint displaying an incorrect 'Date Photo Taken' timestamp that is 14 hours in the future.

How to Fix SharePoint Photo Date and Time Showing 14 Hours Ahead

Product: Microsoft SharePoint
Device & OS: iOS
Scenario: Uploading photos from an iPhone using the OneDrive app or directly to a SharePoint site document library.
Observed behavior: The 'Date Photo Taken' metadata value shows a time approximately 14 hours ahead of the actual capture time, even when SharePoint regional settings are correctly configured for the user's local time zone.

Before you start

Verify that your SharePoint site's regional time zone settings are correct and ensure the original photo on your iPhone displays the correct local time before uploading.

Solution 1Recommended

Create a Calculated Field to Adjust the Timestamp

Use a calculated column to manually offset the incorrect time by subtracting the 14-hour difference as a temporary workaround.

Microsoft support has identified this as a metadata processing defect where SharePoint fails to respect the site's regional time zone settings during the upload process. Until a permanent tenant-level patch is applied, a calculated column is the most effective way to display the correct time.

Add a new column

Navigate to your SharePoint document library, click on 'Add column' at the top of the file list, and select 'More...' from the dropdown menu.

Select column type

In the settings page, choose 'Calculated (calculation based on other columns)' as the column type.

Input the adjustment formula

Name the column (e.g., 'Corrected Photo Date') and in the formula box, enter a formula that subtracts 14 hours from the 'Date Photo Taken' column. Use the formula: =[Date Photo Taken]-(14/24).

Save changes

Set the 'The data type returned from this formula is' option to 'Date and Time', choose your preferred date format, and click 'OK' to save your changes.

Create a Calculated Field to Adjust the Timestamp

Verify Results: Upload a few sample photos from your iPhone to verify that the new calculated column accurately reflects your local time.

Solution 2

Open a Microsoft 365 Service Request

Escalate the bug to Microsoft Support to investigate the time zone defect and apply a fix to your tenant.

Free Microsoft Office alternative

Try WPS Office for Seamless Document and Cloud Management

If you are tired of dealing with complex SharePoint syncing and metadata bugs, WPS Office provides a lightweight, free, and highly compatible alternative to Microsoft Office. With built-in cloud storage and a familiar interface, you can manage your documents and media files effortlessly.

1. Download WPS Office: Visit the official WPS website and download the free desktop or mobile application.
2. Sign in for cloud sync: Create a free account and sign in to access your WPS Cloud storage space.
3. Upload and manage files: Open and save your existing Microsoft Office files directly to WPS Cloud with zero formatting loss.

Fully compatible with Microsoft Office file formats (.docx, .xlsx, .pptx).Built-in WPS Cloud ensures your files and metadata sync accurately across all devices without time zone errors.Lightweight installation with a familiar, easy-to-use user interface.Free to use for everyday document creation and file management needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint change the date taken on my iPhone photos?

This happens due to a known metadata processing bug. When photos are uploaded via OneDrive or directly to SharePoint, the server occasionally fails to apply the site's regional time zone settings to the EXIF data, resulting in an incorrect default time offset.

Can I fix the photo timestamp directly on my iPhone before uploading?

Adjusting the timestamp on your iPhone typically will not resolve this issue. The problem originates on the server side during the upload process, where SharePoint misinterprets the metadata regardless of the device's local time.

Will using a calculated column alter the original photo's metadata?

No. A calculated column only changes how the date is displayed within the SharePoint document library view. The original EXIF data embedded in your uploaded photo file remains completely untouched.

Document & File Issues