SharePoint date metadata is off by 1 day when added as field in a document

A while ago, I was at a customer providing support for their Office 365 implementation and they had a strange issue regarding date metadata which had been added to the document itself as a field.
When they opened the document in Word Online (View mode), it actually displayed the date -1 day. If they opened the document in “Edit” mode, it showed the correct date. Editing the document in the Word client application also displayed the correct date.

I started testing this in our own Office 365 tenant to see if this was a general issue or just a glitch.

I added a date/time column to a document library. I created an empty document and added it to the library. I set the review date for the document.


I opened the document in the Word client and added the field inside the document.

ReviewDateThe correct date is inserted. When I saved the file and reopened it in the Word client application, again, the correct date was displayed.


I returned to my document library and opened the document in Word Online.


And there you go… instead of showing me the correct date, it shows me the date -1 day.

I had this tested by some other people as well and they also confirmed this behaviour.

By Bart

Bart is a certified SharePoint consultant / architect at CTG Belgium NV with a broad professional experience in IT, a background in software development with a specialisation in Microsoft products and technologies and a solid knowledge and experience in Microsoft SharePoint Products and Technologies. He started as a COBOL developer on a mainframe environment and grew into software development for Windows platforms. Participated in projects varying from migrations of existing applications to development of Web applications and Windows applications. Became fascinated by the SharePoint 2007 platform and strongly believed in the added business value of this platform. Is since then fully committed to SharePoint and focuses on SharePoint implementations, migrations, integrations, design and coaching. Stays on top of new developments within the SharePoint technology stack and related technologies.

%d bloggers like this: