Date Query

[Guest]

I want to write a query that will determine if a record should be displayed
based on a date in the database. Here is the basic information. Once a
record has been declared closed, the date of closure is input into the
database. I want that record to show up on any reports that I might run for
7 days after the date of closure, so that we can see that the issue was
resolved. After the 7th day, the record should no longer appear in the
results of the query, but should still be in the database. Can anyone help
me out?

 

[Douglas J. Steele]

WHERE DateOfClosure BETWEEN Date() AND DateAdd("d", 7, Date())

 

[Guest]

Use the following in your criteria:

date()-7

 

[Ron2006]

I think any of your normal report queries would need to be changed to
have two extra criteria:

1) include all records where the close date is Null
( IsNull(Closedate)

2) Include all records where the close date > than date() - 7

Ron