5 Replies Latest reply: Jul 19, 2013 8:58 AM by Vishwaranjan Kumar RSS

    Error in Expression

      Hi there,

       

      I want to show all contracts (agreements) that were Terminated in the month of June.

       

      My formula:

       

       

      if

      ([Date Sold]>='01/06/2013' or <='30/06/2013',count(DISTINCT [Agreement Number]))

       

      It shows an Error in Expression message at the top of the expression box.

       

      The problem is at the smaller or equal to 30/06/2013, because it underlines that symbols in red.

       

       

      Can anyone help me with an alternative way of expressing my formula.

       

      Thanks

      *R*