Show records from today and last seven days

[qshaz]

I want to make a criteria in my query to show me all records only dated today and in the last seven days. How would I enter my criteria for this? Thanks!!

Shazia

 

[dalchri]

You could try:

SELECT *
FROM YourTable
WHERE YourDateField Between Date() And DateAdd("d",-7,Date())

If you are in query design mode instead of SQL mode just type the following into the criteria for your date field:

Between Date() And DateAdd("d",-7,Date())

 

[qshaz]

Thanks!

And supposing I wanted to see all records only from BEFORE the last week (i.e not include last weeks records in this query)?

Thanks again for all your help!

 

[KyleS]

SELECT *
FROM YourTable
WHERE YourDateField Between DateAdd("d",-8,Date())
And DateAdd("d",-14,Date())

Kyle