UFN_REPORT_PROCESSDATE_PARAM

Used by the sponsorship reports to process the date parameters in the matrix dimension

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@DATEPARAM	nvarchar(15)	IN
@RECORDDATE	date	IN

Definition

Copy



CREATE function dbo.UFN_REPORT_PROCESSDATE_PARAM(
    @DATEPARAM nvarchar(15),
    @RECORDDATE date = null)
returns nvarchar(100)
with execute as caller
as begin
    declare @DATEDIMENSION as nvarchar(100);

    set @DATEDIMENSION =
        case 
            when @DATEPARAM in (6,12,49,50) then
                substring(datename(month, @RECORDDATE),1, 3)
            when @DATEPARAM in (43,45,51) then
                'Q' + datename(quarter,@RECORDDATE)
            when @DATEPARAM in (7,13, 53, 54, 55) then
                datename(year, @RECORDDATE)
        end;

    return @DATEDIMENSION
end