date calculation

[comptrtoy1]

I'm trying to do a sql where clause that says:

where date < = to Current Date - 12 months

I tried this:
where date <= Current Date - Months(12)
but it doesn't work any suggestions?

regards
compie

 

[2742]

Your first statement looks good to me. Whats the error?