Beast Mode - UTC to Mountain Time

user03543

Hey!

 

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!

user03543

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

 

Please close

ST_Superman

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.

user03543

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?

 

THanks

user03543

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

 

Please close