EOMONTH() function is introduced in SQL Server 2012. It returns last date of current month. If 2nd argument is specified then specified number of months is added to the start_date and then last date of the month for the resultant date is returned
Syntax
EOMONTH ( start_date [, month_to_add ] ) 1. Finding last date of current month
Select GetDate()As InputDate,EOMONTH (GETDATE()) As Result
Result InputDate Result
2015-03-20 12:24:23.973 2015-03-31
NOTE: this function is useful to find out last date of previous/next months