3 Replies Latest reply on May 16, 2013 12:11 PM by Alex Kerin

    Bug: February 29th not included in Quarter

    Keith Mier

      Quarter([Date]) Returns null for February 29th

      I created a work around with the calculated field ...

           IF MONTH([Date]) <= 3 THEN "Q1"

           ELSEIF MONTH([Date]) <= 6 THEN "Q2"

           ELSEIF MONTH([Date]) <= 9 THEN "Q3"

           ELSEIF MONTH([Date]) <= 12 THEN "Q4" END

       

      I just thought people should be aware of this.