... WHERE (year(table_name.date_field))< year(now())-2

>Kind of a simple question, but I have forgotten how to do it.
>
>I have a table with a date field, and I want to query to see the records 2 years older than the date I run the query. Any advice?
>
>TIA!
>
>MAC