1 Reply Latest reply on Jul 12, 2018 10:07 PM by Zhouyi Zhang

    Time interval calculated field w/ timezone adjustments

    Casey Kelly

      Hello!

       

      I am trying to add a calculated field on a time interval (by 30 minutes, string type) to adjust for different time zones based on the client market segments. Is this possible? Or do you have any other suggestions to do to make this work!

       

      So far this is what I have:

       

      IF ([LocalTime_Client] "AET" AND [Local_Standard_Time] "AUS Standard Eastern Time", THEN [CST_Interval] = [Local_Interval] -14 ) OR..... etc