Date criteria in querys

[wildexodus]

I have a date field in a query. How do i set the criteria so that the query searches for dates between today's date and the date 7 days from now?

 

[raskew]

In the criteria cell for the date, type:
Between Date() And Date()+7