Sharepoint DateTime Timezone Issues

%3CLINGO-SUB%20id%3D%22lingo-sub-2413314%22%20slang%3D%22en-US%22%3ESharepoint%20DateTime%20Timezone%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2413314%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20an%20issue%20with%20a%20SharePoint%20list%20that%20uses%20datetime%20across%20different%20time%20zones.%26nbsp%3B%20This%20column%20is%20really%20only%20needed%20for%20a%20date.%26nbsp%3B%20I%20have%20set%20the%20Time%20zone%20for%20the%20SharePoint%20to%20UTC%2C%20but%20it%20still%20seems%20to%20be%20converting%20the%20time%20for%20users.%26nbsp%3B%20Although%20it's%20saved%20at%20midnight%20on%20a%20date%2C%20if%20you%20attempt%20to%20edit%20the%20date%2C%20it%20shows%204am%20(%20I%20am%20in%20EST%20time%20zone).%20For%20a%20user%20is%20CST%20time%20zone%2C%20all%20of%20the%20dates%20are%20showing%2011pm%20the%20night%20before%2C%20and%20when%20you%20go%20to%20edit%20the%20date%2C%20it's%20showing%204am%20too.%26nbsp%3B%26nbsp%3B%3CSPAN%3EIt%20seems%20as%20though%20it's%20displaying%20in%20local%20time%20but%20saving%20in%20UTC.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20also%20weird%2C%20because%20I'm%20using%20this%20SharePoint%20list%20as%20a%20data%20source%20in%20a%20Power%20App%20with%20Power%20BI%20integration%2C%20and%20it%20won't%20work%20for%20the%20user%20in%20CST%20because%20the%20dates%20don't%20match.%26nbsp%3B%20I%20thought%20it%20would%20use%20the%20stored%20date%20(UTC)%2C%20but%20it%20seems%20to%20be%20using%20the%20local%20date.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20I%20made%20the%20time%20zone%20UTC%20last%20week%20sometime%2C%20so%20I%20don't%20think%20it's%20delay%2Fsyncing%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2413314%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi! 

I'm having an issue with a SharePoint list that uses datetime across different time zones.  This column is really only needed for a date.  I have set the Time zone for the SharePoint to UTC, but it still seems to be converting the time for users.  Although it's saved at midnight on a date, if you attempt to edit the date, it shows 4am ( I am in EST time zone). For a user is CST time zone, all of the dates are showing 11pm the night before, and when you go to edit the date, it's showing 4am too.  It seems as though it's displaying in local time but saving in UTC. 

 

This is also weird, because I'm using this SharePoint list as a data source in a Power App with Power BI integration, and it won't work for the user in CST because the dates don't match.  I thought it would use the stored date (UTC), but it seems to be using the local date. 

 

Also, I made the time zone UTC last week sometime, so I don't think it's delay/syncing issue.

0 Replies