Function to calculate Month End Date

/**********************************************************
Create By    : Hari Narayan Sharma [hari.bagra@gmail.com]
Creation Date: 17 Oct. 2006
Purpose     : To Get the Month End Date
How to Use   : Select dbo.GetMonthEnd('2-20-2004')
**********************************************************/
CREATE Function GetMonthEnd(@Date DateTime)
Returns DateTime
AS
Begin
Set @Date = DateAdd(Month,1,@Date)
Set @Date = Cast(Cast(Month(@Date)As varchar(2))+'-1-'+Cast(Year(@Date)As varchar(4)) As DateTime)
Return DateAdd(Day,-1,@Date)
End