Forum Discussion
Solved
DateTimeZone issue
Hi, I'm importing data from a sharepoint list and one of my columns keeps datetime in UTC (although the site is set to local time). I noticed that during import the column auto-convert to UTC (again...
Check if this functions helps:
https://docs.microsoft.com/en-us/powerquery-m/datetimezone-switchzone
Check if this functions helps:
https://docs.microsoft.com/en-us/powerquery-m/datetimezone-switchzone
Hi camargos88 ,
Thanks a lot ... You guided me to right direction to right family functions - DateTimeZone.
I used a combination of:
DateTimeZone.RemoveZone(DateTimeZone.ToLocal(DateTime.AddZone([Created],0)))