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:




      ([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.