>>
>>You didn't accidentally multiply or divide, instead of subtracting?
>>
>
>No.
>
>>Also check the field width in the report, and the numeric format, e.g. "###" will show asterisks if you have four digits.
>
>I have no choice to specify how many digits to be printed in the column. Just the width of the column. But the values are very small (no more than 4 digits). And in fact when I was using simple DATE_FLD1 - DATE_FLD2 as an expression the number were showing without any problem. It is when I get the DATE_FLD1 - DATE_FLD2 from within IIF() the number are super large. Strange ...
How about a cast().
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)
