Calculating Elapsed Days

[doug]

Could someone help me compare two date fields within a
form to get a value that is then expressed in a third
field? I have a form that has two fields "Current Date"
and "Due Date." I would like to compare these two fields,
find their difference, and write that difference in a
third field "Late?" For the third field, I have tried
building an expression for that field (=[CurrentDate]-
[DueDate]), but to no avail. I researched syntax and
eventually created a module. I referenced this module in
a query in an attempt to create the calculated field that
I wanted, but I got an error message. I need help.
Thanks. Doug

 

[Dan Artuso]

Hi,
Have you looked at the DateDiff function?

 

[Doug]

Thanks for the help. I'll try that.

-----Original Message-----
Hi,
Have you looked at the DateDiff function?

--
HTH
Dan Artuso, Access MVP

Could someone help me compare two date fields within a
form to get a value that is then expressed in a third
field? I have a form that has two fields "Current Date"
and "Due Date." I would like to compare these two fields,
find their difference, and write that difference in a
third field "Late?" For the third field, I have tried
building an expression for that field (=[CurrentDate]-
[DueDate]), but to no avail. I researched syntax and
eventually created a module. I referenced this module in
a query in an attempt to create the calculated field that
I wanted, but I got an error message. I need help.
Thanks. Doug

.