Beast Mode - UTC to Mountain Time



I need help with doing a beast mode calculation. I have 'Date SO Created" and it has UTC time zone, which I need to convert to Mountain Time. 


The data is shown as "6/4/2018 2:41:00 AM"


I heard about CONVERT_TZ and I have tried plugging it in myself, but nothing is validated.


Thank you!

Best Answer

  • user03543
    Answer ✓

    Nevermind, I figured how to add time to my data. Thanks!


    Please close


  • Have you tried using CONVERT_TZ as part of a dataflow rather than in a beastmode?  I don't think that funciton is available in beast mode.

    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • My BI specialist does most of the backend work and he has a few projects to work on.


    There is a 6 hours difference between the UTC and Mountain Time.. Could I just add 6 hours to the data. If so, how?