Calculating Elapsed Days

  • Thread starter Thread starter doug
  • Start date Start date
D

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
 
Thanks for the help. I'll try that.
-----Original Message-----
Hi,
Have you looked at the DateDiff function?

--
HTH
Dan Artuso, Access MVP


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


.
Click to expand...
 
Back
Top