2 weeks prior

Z

Zanstemic

I have a querie that displays a list of records that need to be scheduled.
I'm looking for a where clause that would give me on records that the date is
within two weeks of the date.

where date = ?

Any suggestions are appreciated.
 
V

vanderghast

WHERE dateStamp BETWEEN DateAdd("d", -14, date( ) ) AND DateAdd("d", 14,
date( ) )

for a total range of 28 days (14 in the past, 14 in the future).



Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

not in criteria fails 2
Need formula for a querie! 9
problems with counting and summing records in a query 1
Most recent date prior to test date. 1
Calculating weeks 1
Querying Dates 5
Slow Query 3
Last Years Sales Data based on Fiscal Week 5

Top