2 weeks prior

[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.

 

[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