Over Due Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with a open date and a due date, the difference is 7 days
between these two dates. I need to show an over due date after the 7th day.
How can I do this?

Thank you
 
Tina,
Not sure what you mean, but to find all records that a past DueDate put
this criteria in the DueDate field in your report query...
< Date()
Any DueDate that is less than today's date would qualify.
 
I'm sorry, I wasn't very clear. I have an OpenDate, which is the date the
problem was first noted. We have 7 days to answer the problem, so I set the
DueDate to calculate 7 days from the OpenDate. Then I have a DateComplete,
if the DateComplete is Null or after the 7 days, I need a report to show
these records as being OverDue. I hope this makes sense. I appreciate your
help.
 
If a record has a CompleteDate entered...I wouldn't call that OverDue...
it's been completed.
The only folks OverDue are those whose DueDates are less than Today's date.
DueDate<Date()
 
You have

(DueDate<=Date() and DateComplete Is Null)
OR
DueDate>DateComplete

First Line finds those items that are still open (no date complete), but should
be closed as of today's date.
Second line finds any items that took too long to close.
 
Back
Top