Date Criteria

[I50]

Please Help me on this one,

I have a Query that I want to interrogate records that has a "Date" thats more than five years old. How do I code the criteria for selecting these records. I tried using
the 'DateAdd' function, such as, ">DateAdd("m",60,Date())".
But, I'm not getting the proper results. Need Help! Thanks.

 

[jhall156]

>DateSerial(DatePart("Y",Date)-5,DatePart("m",Date),DatePart("d",Date)) JHall

 

[I50]

The following expression when run comes up with a message that says, "Data type Mismatch in Criteria expression". Why is this?

>DateSerial(DatePart("y","Date&quot-5,DatePart("m","Date&quot,DatePart("d","Date&quot)

 

[jhall156]

replace each of the "Date" with Date() with no quotes JHall