Help with date query

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

Guest

I have two fields in a sub form that I would like to setup. The first field
is Problem report date, and the second is Resolution Date. What I would like
is to have the query tell me when a problem that was reported is 30 days past
the starting point, but there is no resolution date. So if I report a
problem, and it is resolved within 30 days, nothing would appear in this
query. Only the ones that are past 30 days and unresolved.
 
Get those with no resolution date and Problem Report date is over 30 days
old

WHERE [Problem Report Date] <= DateAdd("d",-30,Date) AND [Resolution Date]
IS NULL

Get those with more than 30 days elapsed between the Problem Report Date and
the resolution date OR more than 30 days elapsed between the [Problem Report
Date] and today's date where Resolution date is null (blank)

WHERE DateDiff("d",[Problem Report Date],Nz([Resolution Date],Date())) > 30

If I got that right, then
 
Back
Top