Field= Todays Date - CheckOutDate

[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

 

[John Vinson]

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.

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.