Date question

J

Jacob

I have a table with end date on contracts. I want to run a query that shows
all contract 1 month before their end date. Does anyone know the criteria I
need to use. I have tried Month(Date())-1 and that did not work.
 
A

ALESSANDRO Baraldi

Jacob said:
I have a table with end date on contracts. I want to run a query that shows
all contract 1 month before their end date. Does anyone know the criteria I
need to use. I have tried Month(Date())-1 and that did not work.
Click to expand...


Try to use DateDiff

Bye.
 
Top