declare @Date datetime
set @Date = '2009/10/17'
Select dateadd(day, 0 - day(dateadd(month, 1 , @Date)), dateadd(month, 1 , @Date))
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.