Whats New in SQL Server Denali: EOMONTH() function to Get Last Date of

EOMONTH() is a new function introduced in SQL Server Denali CTP3. Purpose of this function is to avoid lengthy tsql code to get last day of any given month.