DECLARE @Dt DATETIME SET @Dt = '2011-06-30' IF MONTH(@Dt) != MONTH(DATEADD(DAY,1,@Dt)) PRINT 'End Of Month'