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>
 

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

Excel Help with dates 2
Help with expression builder in a Query to retrieve wanted dates 2
Use DATE in query expression 1
query using datediff to calculate time in years and months 2
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
How do you subtract two dates in an expression? 3
Access Building a IIF expression in Access 0
Calculate Quantity between dates 2

Top