i have created a database and need to calculate the no of days which a payment is overdue.

i need it to do the following
takeaway the current date by the date to be paid.

i have tried the following.
OVERDUE: DateDiff("d",[date to be paid],[now()])

But has not worked. any ideas?

OVERDUE: DateDiff("d",[date to be paid],now())

or

OVERDUE: DateDiff("d",[date to be paid],date())


Now() returns the current date/time whereas date() returns the current date.

hth
Chris