DATE DIF EXPRESSION

[Guest]

I have a duedate and recdate that I would like to know what the days between
are
I have tried DATEDIF([DUEDATE],[RECDATE], "D") it is unidentified.

Help.
Mary Lou

 

[Duane Hookom]

Try:
DateDiff("d",[Earlier Date], [Later Date])

 

[MGFoster]

I have a duedate and recdate that I would like to know what the days between
are
I have tried DATEDIF([DUEDATE],[RECDATE], "D") it is unidentified.

Syntax is incorrect:

DateDiff("d", duedate, recdate)

Or

recdate - duedate