Hi Folks,

Try this to get get last day of month

CREATE FUNCTION [dbo].[ufn_GetLastDayOfMonth] ( @pInputDate DATETIME )

RETURNS DATETIME

BEGIN

DECLARE @vOutputDate DATETIME

SET @vOutputDate = CAST(FLOOR(CAST(@pInputDate AS DECIMAL(12, 5))) -

(DAY(@pInputDate) - 1) AS DATETIME)

SET @vOutputDate = DATEADD(DD, -1, DATEADD(M, 1, @vOutputDate))

RETURN @vOutputDate

END

GO