View Full Version : Date criteria in querys


wildexodus
04-22-2003, 02:42 PM
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
04-22-2003, 04:21 PM
In the criteria cell for the date, type:
Between Date() And Date()+7