2 weeks prior

  • Thread starter Thread starter Zanstemic
  • Start date Start date
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.
 
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
 
Back
Top