dates and Between

[GregB]

I know I can set the critera in a query for dates to be like BETWEEN #date1#
AND #date2#

How can I make it so that it always returns results from the last two weeks?
BETWEEN #two weeks ago# AND #today#

Thanks

 

[boblarson]

That would be:

Between DateAdd("d",-14,Date()) And Date()
--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[John Spencer]

See if this gives you the results you want
Between DateAdd("ww",-2,Date()) and Date()

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Dirk Goldgar]

I know I can set the critera in a query for dates to be like BETWEEN
#date1#
AND #date2#

How can I make it so that it always returns results from the last two
weeks?
BETWEEN #two weeks ago# AND #today#

If there are no future dates in this field, you could use

DateAdd("d",-14,Date())

Or you might want to us ">=" instead of ">"; it's not clear to me.