DATE DIF EXPRESSION

M

MaryLou

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
 
M

MGFoster

MaryLou said:
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.
Click to expand...

Syntax is incorrect:

DateDiff("d", duedate, recdate)

Or

recdate - duedate
 
Top