Thursday, October 15, 2009

Year to date for a particular date

select max(dailydate)dailydate from tbldate where
month(dailydate)<=month('10/09/09') and day(dailydate)<=day('10/09/09')
and year(dailydate)<=year('10/09/05')
group by year(dailydate)
order by dailydate desc