Date Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bk - 11 Jun 2007 21:18 GMT

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?

Reply to this Message

Douglas J. Steele - 11 Jun 2007 21:34 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>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
[quoted text clipped - 6 lines]
> help
> me out?

Reply to this Message

Robert_DubYa - 11 Jun 2007 21:38 GMT

Use the following in your criteria:

>date()-7

> 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
[quoted text clipped - 4 lines]
> results of the query, but should still be in the database. Can anyone help
> me out?

Reply to this Message

Ron2006 - 12 Jun 2007 16:17 GMT

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

Reply to this Message