This content has been marked as final. Show 5 replies
I want to show all contracts (agreements) that were Terminated in the month of June.
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.