Date diff

[christy]

I am trying to work out the difference of 2 dates so that i can see how many days a bill is overdue.

I thought this code would work

=DateDiff("d",[DueDate],Date())

Can someone please advise..Thanx in advance.Christy

 

[Abby N]

That looks good to me. What seems to be the problem?

~Abby N

 

[Jack Cowley]

DateDiff("d",[DueDate],Date) does work. Access removes the () following Date.

 

[christy]

When i use this code in text box it shows up like this #Name in the report. I ca'nt see what the problem is!

 

[Richie]

Are you sure duedate is in the underlying record source?