getting date less than 3 yr.s old

[dotnetcsharpdev]

select myDate from myTable where myDate > datediff(yyyy,now,myDate)=> 3) I want to select date which is greater that   now - 3 years(less than 3 yr.s old) above query gives me following error:- Msg 102, Level 15, State 1, Line 5 Incorrect syntax near '=' :sigh:

[dotnetcsharpdev]

got it   :-D Posting it here if it might help anyone in future !!.. select myDate from myTable where datediff (yyyy,myDate ,getdate()) <= 3

[zeusToronto]

select * from yourtablename where DateDiff(year, myDate, getdate()) >= 3