Date question

  • Thread starter Thread starter Jacob
  • Start date Start date
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.
 
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.
 
Back
Top