LISTING 2: The IsDateLastDayOfMonth UDF

CREATE  FUNCTION IsDateLastDayOfMonth
(@InputDate datetime)
RETURNS int
AS
BEGIN

RETURN (SELECT DATEDIFF ( mm , @InputDate, @InputDate + 1 ))
END
GO
SELECT dbo.IsDateLastDayOfMonth('2001-11-30')