How do I select records less than 1 year old?

select *
from MyTable
where MyDate > DATEADD(year, -1, GetDate())

select ... from ... where YEAR(GETDATE()) - YEAR(YOURDATE) = 1

TRY

SELECT * FROM TABLE_NAME WHERE SYSTEM_DATE > DATEADD(YYYY, -1, GETDATE())

(UNTESTED)