Last day of Month

First add one month with given date AND substract the day from given result date.

DECLARE @Dt DATETIME
SET @dt = '29-Jan-2011'

SELECT DATEADD(DAY,-DAY(DATEADD(MONTH,1,@dt)),DATEADD(MONTH,1,@dt)) As LastDayOfMonth