I am having nightmares with these functions in the Report Designer.
Here is a simple formula that is not working and I cannot figure out why:
Iif(([CallReport.ComplaintCode] = 'CA' and [CallReport.DateReceived] >= AddDays(Today(),-30)), 1, 0)
Can someone help me out with this. I have been designing reports for almost 15 years now and have never seen so many inconsistencies with a report designer. Sometimes it works, and sometimes it doesn't. And I cannot figure out why.
It could be me, but this is a very basic formula I have here!!