Forum Discussion

vincenardo's avatar
vincenardo
Helper I
5 years ago

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' ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ok, your last step name is #"Reordered Columns1", so:

 

= Table.TransformColumns(#"Reordered Columns1", {{"AbsentStart", DateTimeZone .ToLocal}, {"AbsentEnd", DateTimeZone.ToLocal}})

 

 

vincenardo's avatar
vincenardo
Helper I
5 years ago

Appreciate the help, still have an issue;

Here is the dataset before I put in the Code you suggested (The AbsentStart_PST was using a different way to conver the AbsentStart)

 

I inserted the code you suggested (Custom1) - and I get this error on the AbsentStart and AbsentEnd.

 

 

Any ideas? I like your suggestion the best because the code is much less then what I used and will ensure the time is coverted to the local time.