ALTER FUNCTION [dbo].[ufn_JIWA_GL_YearNo] (@TranDate DATETIME)
RETURNS SMALLINT
AS
BEGIN
--Used by:
--
--ufn_JIWA_GL_PeriodNo
RETURN (
SELECT
TOP 1 YearNo
FROM
GL_Config WITH (NOLOCK)
WHERE
@TranDate >= YearStartingDate AND @TranDate <= dbo.ufn_JIWA_GL_YearEndingDate(YearNo)
ORDER BY YearStartingDate ASC)
END
GO
Return to Technical and or Programming
Users browsing this forum: pricerc and 5 guests