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

    When editing the table, can you give me the steps on where to add it? I can't figure where to place it, I assume it's not in a new column. Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Sorry, under your applied steps, right click on the last step, click "Add new step". Then copy and paste everything including the "=" into the formula bar. 

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