create a GetFiscalYearEnd function

GO
IF OBJECT_ID (N'dbo.GetFiscalYearEnd', N'TF') IS NOT NULL
    DROP FUNCTION dbo.GetFiscalYearEnd;
GO
CREATE FUNCTION dbo.GetFiscalYearEnd(@FiscalYearNumber SMALLINT)
RETURNS DateTime
AS
BEGIN
     DECLARE @FiscalYearEndDate DateTime;
     SET @FiscalYearEndDate = 
     (SELECT FiscalYearEndDate
         FROM FiscalCalendar
         Where FiscalCalendar.FiscalYearNumber = @FiscalYearNumber)
     RETURN(@FiscalYearEndDate);
END;