Forum Discussion
Post ProdigyConverting UTC to NZ standard time
Hi Dunner2020
You need to supply a DateTimeZone value to DateTimeZone.Switch, you're only supplying a #datetime value
DateTimeZone.SwitchZone - PowerQuery M | Microsoft Docs
#datetimezone - PowerQuery M | Microsoft Docs
I'm confused, if you are supplying a #datetime value (presumably this is in the column?) why not just create/change the time to UTC directly? Why does your column have #datetime in it rather than actual DateTimeZone values?
Regards
Phil
Super UserHi Dunner2020
You need to supply a DateTimeZone value to DateTimeZone.Switch, you're only supplying a #datetime value
DateTimeZone.SwitchZone - PowerQuery M | Microsoft Docs
#datetimezone - PowerQuery M | Microsoft Docs
I'm confused, if you are supplying a #datetime value (presumably this is in the column?) why not just create/change the time to UTC directly? Why does your column have #datetime in it rather than actual DateTimeZone values?
Regards
Phil