Using dates in queries

[LoneAngel666]

Hey all,

I'm currently writing a query that is meant to display a list of all properties that were being rented within the last 24 months. However, the closest I can get to writing any kind of suitable criteria is this:

>Date()-(24*28)

I'm sure there is a better way to write this out - something a little more accurate too - anyone?



Rob

 

[Nouba]

You can use the DateAdd function for your purpose.

>DateAdd("yyyy", -2, Date())

 

[LoneAngel666]

Thanks, that was perfect

I knew there was an easy way

Rob