Get Last date of Month

declare @DT datetime

set @DT = '1/15/2012'

SELECT DATEADD(MM, DATEDIFF(MM, 0, @DT) + 1, 0)-1 AS MonthEndDate