Forum Discussion
gabibalaban
5 years agoNew Member
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) considering my datatime values as local.
Is there any way to correct this ?
Thank you.
Check if this functions helps:
https://docs.microsoft.com/en-us/powerquery-m/datetimezone-switchzone
2 Replies
- camargos88Community Champion
Check if this functions helps:
https://docs.microsoft.com/en-us/powerquery-m/datetimezone-switchzone
- gabibalabanNew Member
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)))