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

Try this:

 

= Table.TransformColumns(#"Resource Absence", {{"AbsentStart", DateTimeZone .ToLocal}, {"AbsentEnd", DateTimeZone.ToLocal}})

vincenardo's avatar
vincenardo
Helper I
5 years ago

I recieved this error; ??

Expression.Error: A cyclic reference was encountered during evaluation

 

  • 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.