DateTimeZone issue

[gabibalaban]

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. 

[camargos88 · Accepted solution]

@gabibalaban ,

Check if this functions helps:

https://docs.microsoft.com/en-us/powerquery-m/datetimezone-switchzone

[gabibalaban]

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)))