You can add to the query the DateDiff function.
so:
select date from products
where DateDiff(m, date, GetDate()) < 13
In this case the differences in monthes between the DATE field and the current date ->GetDate() function is returnen in the result from the query. You have solved your problem in the select. No postprocessing with TimeSpan object is needed.