DAYS 360 Function

Hi,

Does anyone has the DAYS360 excel formula in a function in sqlserver ?? I did this one



FUNCTION dbo.fnDays360_EXCEL
(
@startDate DateTime,
@endDate DateTime
)
RETURNS int
AS
BEGIN
RETURN (
(CASE
WHEN Day(@endDate)=31 THEN 30
ELSE Day(@endDate)
END) -
(CASE
WHEN Day(@startDate)=31 THEN 30
ELSE Day(@startDate)
END)
+ ((DatePart(m, @endDate) + (DatePart(yyyy, @endDate) * 12))
-(DatePart(m, @startDate) + (DatePart(yyyy, @startDate) * 12))) * 30)
END



But there is a bug, if the end date is bigger then february, february must have 30 days and not 28 or 29...



Does anyone has the solution ?





Thanks