New Date Function Of Sql Server 2012

you can add months also using this function by passing duration in second parameter.

DECLARE @Currentdate DATETIME

2.SET @Currentdate = '12/12/2010'

3.SELECT EOMONTH ( @Currentdate,-2 ) AS Result;

4. 

5./*Result

6.2010-10-31 */