Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use MAX() in a calculated field?
Message
From
26/01/2007 14:22:03
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Stonefield
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01189404
Message ID:
01189762
Views:
7
>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.
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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform