UFN_RETURNFISCALYEAR

Return

Return Type
varchar(4)

Parameters

Parameter	Parameter Type	Mode	Description
@InputDate	datetime	IN
@FiscalMonthStart	int	IN

Definition

Copy


create function [BBDW].[UFN_RETURNFISCALYEAR]
               (@InputDate        datetime,
                @FiscalMonthStart int  = 1)
returns varchar(4)
as
  begin
    -- UDF which returns the Fiscal year based on the input date and fiscal month start
    declare  @CurrentYear varchar(4)
    declare  @NextYear varchar(4)
    declare  @CurrentMonth int
    declare  @FiscalYear varchar(4)
    set @CurrentYear = convert(varchar(4),year(@InputDate))
    set @NextYear = convert(varchar(4),year(@InputDate)
                                         + 1)
    set @CurrentMonth = month(@InputDate)
    if @FiscalMonthStart = 1
      begin
        set @FiscalYear = @CurrentYear
      end
    else
      begin
        if @CurrentMonth < @FiscalMonthStart
          set @FiscalYear = @CurrentYear
        else
          set @FiscalYear = @NextYear
      end
    return (@FiscalYear)
  end;