• 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?