UFN_KPIINSTANCEHISTORY_GETCLOSESTASOFDATE

Gets the closest as-of date of a KPI instance value for a given date.

Return

Return Type
datetime

Parameters

Parameter	Parameter Type	Mode	Description
@KPIINSTANCEID	uniqueidentifier	IN
@ASOFDATE	datetime	IN

Definition

Copy



            CREATE function dbo.UFN_KPIINSTANCEHISTORY_GETCLOSESTASOFDATE(@KPIINSTANCEID uniqueidentifier,
                @ASOFDATE datetime)
            returns datetime
            as
            begin

                declare @RETURNVALUE datetime;

                select top(1)  @RETURNVALUE = ASOFDATE 
                    from KPIINSTANCEHISTORY 
                    where KPIINSTANCEHISTORY.KPIINSTANCEID = @KPIINSTANCEID
                        and KPIINSTANCEHISTORY.ASOFDATE <= dbo.UFN_DATE_GETLATESTTIME(@ASOFDATE) 
                    order by KPIINSTANCEHISTORY.ASOFDATE desc

                return @RETURNVALUE;

            end;