Hi all, I have a split DB with 4 calculated fields that show the number of days between the dates entered in other fields. Sometimes the results are negative as one would expect. What I'd like to do is have the field set to 0 if the calculation is less than 0 to prevent any skewed reporting. I suspect I would use the IIf function to do this, but I'm not sure how to go about it. My attempts so far have returned improper syntax errors.
My expression for one of the fields is: Day([Close Date])-Day([Created Date])
I tried it as: IIF(Day([Close Date])-Day([Created Date])<"0",[Days Active]="0")
Am I able to add it on the expression or would it require a query? How, exactly, should I apply it to the fields so that it changes the result to 0 in the table?