2 Replies Latest reply on Apr 10, 2016 11:18 PM by Antonio Tena

    What is wrong with this query?

    Antonio Tena

      Hi,

       

      I am trying to group some datas and I am using this query:

       

      IF

      [Transactiondate] > #31/08/2014# AND  < #21/03/2015# THEN "1"

      ELSEIF

      [Transactiondate] > #31/08/2015# AND  < #21/03/2016# THEN "2"

      END

       

      But it seems that the first < doesn´t work (but not the second)

       

      Can you help me to figure out why this is happening?