10 Replies Latest reply on Nov 29, 2012 2:17 PM by Shawn Wallwork

    daylight savings time

    Dave Araujo

      I'm sure one of you datagurus can do this easy, but My mind hurts.

       

      I have a great formula to convert Central daylight time and central standard time into GMT.

      =if(and(A2>date(year(A2),4,1-weekday(date(year(A2),4,0)))+1/24,A2<date(year(A2),11,1-weekday(date(year(A2),11,0)))+1/24),5,6)/24+A2

       

      but I'm having trouble getting a good tableau formula.

       

      I can't use AND

      I can't use BETWEEN

       

      I hope someone out there has ideas.

       

      thanks