date field question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a criteria that i can put in a query

Date() - 1 Years
or
Date() - 2 Years
or
Date() - 1 month
or
Date() - 2 months
 
Database said:
is there a criteria that i can put in a query

Date() - 1 Years
or
Date() - 2 Years
or
Date() - 1 month
or
Date() - 2 months
Click to expand...


WHERE DateField = DateAdd("yyyy", -1, Date())
or
DateField = DateAdd("yyyy", -2, Date())
or
DateField = DateAdd("m", -1, Date())
or
DateField = DateAdd("m", -2, Date())
 
Hi i'm trying to do this but its not seeming to work maybe i'm putting it in
the wrong place. I have a field in my query called [Date Paid] and i want in
the criteria to only bring up those that the Date Paid is whatever date but
it has to be 3 months ago from todays date. So i put under criteria of Date
Paid = DateAdd("m", -3, Date())

Am i doing something wrong?

Thanks for your help!
 
Back
Top