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
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
2 matches
Mail list logo