Expression builder to manipulate dates

  • Thread starter Thread starter Diane
  • Start date Start date
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.
 
Diane

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

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

(adding a negative number is subtracting)

Jeff Boyce
<Access MVP>
 
Back
Top