Error in Expression

[#1]

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*

[#2]

Try

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

[jerem1234]

try:

if

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

[#4]

try

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

[techvarun]

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

Please try this

[#6]

firstly in script write your date field according to this format--

date(date#([Date Sold],'DD/MM/YYYY'),'DD/MM/YYYY') AS [Date Sold]

THE TRY THIS

count(distinct if([Date Sold]>='01/06/2013' and [Date Sold] <='30/06/2013', [Agreement Number]))