datediff function

[Dan]

How can i say in a query using the datediff function
less than 2 months from the current date?

 

[Les]

You may want to use the dateadd function:

dateadd("m", -2, date())

 

[John Spencer (MVP)]

YOUR request is a bit ambiguous.

Do you want dates that are:
between today's date and two months in the past;
between today's date and two months in the future;
between two months in the past and two months in the future;
after two months in the past;
before two months in the past;
or something else?


Any date that occurs after two months ago
Field: SomeDate
Criteria: >DateDiff("m",-2,Date())

 

[dan]

Thank you this worked for the month i tried using
this for the year and put in "yyyy" in place of month
but it did not work would you happen to know why?

 

[John Spencer (MVP)]

Sorry that should have used the DateADD function NOT the DateDiff Function.