>>>The problem is definitely with the IIF() and probably the way SFReports views it. I changed my IIF() expression to
>>>IIF( DATE_FLD1 > DATE_FLD2, 1, 0 ) and I still see bunch of asterisks.
>>
>>Did you try a UDF, which might be named MyMax()? I understand UDFs are not an acceptable in your case, but I mean, just to aid in the detective work, by comparing results.
>
>Yes, I did try UDF and it works. I actually went ahead with the UDF as the solution to this problem.
>
>Thank you for your help.
I suppose that if you place commonly used UDFs in the database container (stored procedures), they should normally be available - but I don't know how this works with VFP as a database server.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)