My date column is 6 hrs back

%3CLINGO-SUB%20id%3D%22lingo-sub-2133025%22%20slang%3D%22en-US%22%3EMy%20date%20column%20is%206%20hrs%20back%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2133025%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20date%20column%20is%20back%206%20hrs.%20Not%20sure%20why.%3C%2FP%3E%3CP%3EI%20have%20checked%20the%20region%20setting%20is%20correctly%20showing%20as%20my%20time%20zone.%3C%2FP%3E%3CP%3EAlso%2C%20I%20have%20used%20the%20UTC%20to%20my%20timezone%20convertion.%3C%2FP%3E%3CP%3EThe%20Flow%20shows%20the%20dates%20perfectly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20my%20test%20%3A%3C%2FP%3E%3CP%3EIt%20was%20few%20minutes%20past%20midnight.%26nbsp%3B%202%2F14%2F2021%2012%3A05AM%20(Flow%20output%20showed%20this%20time%20%26amp%3B%20Date)%20%26amp%3B%20my%20flow%20writes%20to%20a%20date%20column%20as%202%2F13%2F2021%206%3A05PM%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20my%20SharePoint%20is%206%20hours%20back.%20why%3F%3C%2FP%3E%3CP%3ECan%20any%20one%20interpret%20this%20for%20me%20please.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EC1%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2133025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hi all

 

My date column is back 6 hrs. Not sure why.

I have checked the region setting is correctly showing as my time zone.

Also, I have used the UTC to my timezone convertion.

The Flow shows the dates perfectly.

 

Here is my test :

It was few minutes past midnight.  2/14/2021 12:05AM (Flow output showed this time & Date) & my flow writes to a date column as 2/13/2021 6:05PM

 

See my SharePoint is 6 hours back. why?

Can any one interpret this for me please.

 

Thanks

C1

0 Replies