Hi,
A table has two date fields DateBorrowed, DateReturned
I am building a query and need the following:
1- A calculated field: DueDate = DateBorrowed+ 21 days
2- A Calculated field: DaysLate = DateReturned - DueDate
The aim of the criteria is find DaysLate that is greater than 21 days.
I am struggling with it. Any help is appreciated
Khalil