Syntax for IIF statement in report writer

I am using the CF report builder and having a tough time with a conditional statement. What I want to achieve is a field on the report that says either "C" or "FFS" What I want this to say is... If #query.capdate" is before January 1, 1900, show "FFS", otherwise show "C" How do I make this work

Re: Syntax for IIF statement in report writer

Due to the double evaluation nature of IIF, you have to double escape text results in IIF. For example: IIF(1 eq 1, '"one"', '"not one"') What you see there is single quotes around double quotes. This can also be done with the DE() function, but that's a waste in my mind. http://www.fusionauthor