• I achieved it proceeding like this

    select startdate, case when startdate>=convert(datetime,'1 July '+convert(varchar,datepart(yyyy,GETDATE())))

    then '1 Jan 1900' else startdate end Datecalc from MARKETSHARE order by Datecalc desc

    anyway thanks all of you for providing me the idea to proceed