UFN_GLFISCALYEAR_GETIDFROMDATE

Returns GLFISCALYEARID for current date.

Return

Return Type
uniqueidentifier

Definition

Copy



CREATE function dbo.UFN_GLFISCALYEAR_GETIDFROMDATE()
    returns uniqueidentifier 
        as            
        begin
            return (select GLFISCALYEARID  from dbo.GLFISCALPERIOD where dbo.UFN_DATE_GETEARLIESTTIME(GETDATE()) between STARTDATE and ENDDATE )
        end