Previous and next month last day for date

SQL EOMONTH() function is a date function , it returns the last day of the month of a specified date, with an optional offset.