Date column is reduced by 1 day when editing file in Word

%3CLINGO-SUB%20id%3D%22lingo-sub-1860506%22%20slang%3D%22en-US%22%3EDate%20column%20is%20reduced%20by%201%20day%20when%20editing%20file%20in%20Word%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1860506%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20a%20sharepoint%20library%20with%20date%20columns%20for%20%22Issue%20date%22%2C%20%22Last%20review%20date%22%20and%20%22Next%20review%20date%22%2C%20that%20are%20mannually%20populated%20inside%20MS%20Word%20and%20become%20part%20of%20the%20document%20header.%20If%20I%20set%20the%20dates%20from%20sharepoint%2C%20using%20the%20document%20info%20panel%2C%20it%20is%20displayed%20correctly%20in%20Sharepoint%20and%20Word.%20If%20I%20set%20it%20from%20inside%20MS%20Word%2C%20in%20the%20document%20properties%2C%20it%20is%20displayed%20correctly%20in%20Word%2C%20but%20the%20date%20is%20reduced%20by%201%20day%20in%20sharepoint.%3C%2FP%3E%3CP%3EI%20guess%20this%20is%20related%20to%20timezone.%20I%20am%20located%20in%20Brazil%2C%20timezone%20UTC-3%20(Bras%C3%ADlia)%2C%20but%20I%20have%20no%20clue%20on%20how%20to%20correct%20this%20behaviour.%3C%2FP%3E%3CP%3EBelow%20pics%20to%20illustrate%20(date%20format%20is%20dd%2Fmm%2Fyyyy).%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MauricioSouza_BR_0-1604663256299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231871i10F3E93EBE9C9D0C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MauricioSouza_BR_0-1604663256299.png%22%20alt%3D%22MauricioSouza_BR_0-1604663256299.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MauricioSouza_BR_1-1604663296581.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231872i0851ADEECD22AA30%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MauricioSouza_BR_1-1604663296581.png%22%20alt%3D%22MauricioSouza_BR_1-1604663296581.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20appreciate%20your%20help%20with%20that.%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EMauricio%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1860506%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello, I have a sharepoint library with date columns for "Issue date", "Last review date" and "Next review date", that are mannually populated inside MS Word and become part of the document header. If I set the dates from sharepoint, using the document info panel, it is displayed correctly in Sharepoint and Word. If I set it from inside MS Word, in the document properties, it is displayed correctly in Word, but the date is reduced by 1 day in sharepoint.

I guess this is related to timezone. I am located in Brazil, timezone UTC-3 (Brasília), but I have no clue on how to correct this behaviour.

Below pics to illustrate (date format is dd/mm/yyyy).

MauricioSouza_BR_0-1604663256299.png

MauricioSouza_BR_1-1604663296581.png

 

 

I appreciate your help with that.

Best regards,

Mauricio

0 Replies