Field= Todays Date - CheckOutDate

  • Thread starter Thread starter Katayon
  • Start date Start date
K

Katayon

Hi,

The database is a software library.
I have a field in a database called OverDue.
I would like this field to calculate the OverDue date,
i.e. today's date subtracted by the checkout date.

Can someone please let me know how to do this as soon as
possible. I really appreciate it.

Thanks,
Katayon
 
Hi,

The database is a software library.
I have a field in a database called OverDue.
I would like this field to calculate the OverDue date,
i.e. today's date subtracted by the checkout date.

Can someone please let me know how to do this as soon as
possible. I really appreciate it.
Click to expand...

Well... DON'T.

If you put a value in this field today, IT WILL BE WRONG TOMORROW.
Guaranteed!

Instead, calculate it on the fly. Create a Query based on your table,
and in a vacant Field cell type

OverDue: DateDiff("d", [CheckOutDate], Date())

to calculate the number of days since the checkout date. Subtract 14
or however many days before the item becomes overdue.

This calculated field can be used for searching, for sorting,
displayed on a form or report - the only thing you can't do is edit
it.
 
Back
Top