Expression builder to manipulate dates

D

Diane

I used the following expression to find records containing
expiration dates 3 months "from" today's date - which
works great - I need it to find dates 3 months "before"
today's date:

Between Date() And DateAdd("m",3,Date())

Shouldn't there be a DateSubtract ? Just a thought.
 
J

Jeff Boyce

Diane

(prepare for a "V8" moment...)

Between Date() And DateAdd("m",-3,Date())

(adding a negative number is subtracting)

Jeff Boyce
<Access MVP>
 
Top