First of all Wish you and your family a Happy deepawali.
Now “EOMONTH” is new function in SQL Server 2012 by the name you understand it give last date of month.
Please see below screen to understand it more
I hope you will enjoy this function with deepawali festival.
Thanks & Best Regards,