Forum Discussion
Convert Date Time in UTC to PST
I have a date / time field coming in from a connection to Salesforce. The date/time is stored in UTC and I need to transform it to PST (our local time). I tried to edit the query and 'transform' ...
To make the Datetime correct its value, as opposed to only adding the Time Zone, just use this one function, instead of changing the data type to datetimezone:
= Table.TransformColumns(PriorStepOrTableName, {{"AbsentStart", DateTimeZone .ToLocal}, {"AbsentEnd", DateTimeZone.ToLocal}})
This will add your local time zone to the datetime, and also offset the actual value by the difference in hours from UTC to PST.
--Nate
Can you give me some additional instructions on how to add this? The table name is ‘Resource Absence’ not sure where to add this…
Thank you!
