can conditonal expression have 2 conditions with and operator defined between th

[prathi selva via AccessMonster.com]

Hi,
In my report i want to calculate if date received - date acknowledged is
less than 5 and final reply is less than response date, i should display 1
else 0.
i tried the following Expression..but i get this error :

IIf((DateDiff("d",[Date_Received],[Date_Acknowledged])<5) And ([Final_reply]
<=[Response_date]),1,0)

"This expression is typed incorrectly, or it is too complex to be
evaluated. For example, a numeric expression may contain too many
complicated elements. Try simplifying the expression by assigning parts of
the expression to variables. (Error 3071)"

 

[Klatuu]

Pardon me if this is a duplicate, but I got an error posting.
I think this may be a data type problem. Is [Final_reply] a date data
type? What about the others?

 

[Klatuu]

Is [Final_reply] a date data type? I assume the others are. It looks like
it may be a data type problem.