Iff and DateDiff

[adagio12]

IIf(day()>ReturnDate, DateDiff("d", day(), ReturnDate), 0)
.
.
.
I intend it to be:

"If today's date is > ReturnDate,
Find the difference between Today's date and the ReturnDate,
Otherwise, return '0' as the number of days."

Could somebody tell me why this formula isn't working out for me?
It keeps saying that this function 'contains the wrong number of arguments'.

The date values on the 'ReturnDate' field are calculated dates from another query.

Thanks in advance!

 

[pbaldy]

You want Date(), not Day().

 

[adagio12]

omg, finally, it works!
THANK YOU

 

[pbaldy]

LOL! Happy to help.