Thanks!
SELECT TYPE,vendor,discontinueddate, datepart(quarter, GETDATE()) AS 'Quarter'
from EOL
WHERE (DISCONTINUEDDATE >= '01/01/2005')
Order by discontinueddate
works and returns the Current quarter but how do I change the GETDATE to cover all years 2005 and above?