UFN_WIDGETDASHBOARD_GETSTARTENDDATE

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@STARTDATE	date	IN
@ENDDATE	date	IN
@SPECIFICDATE	date	IN
@FILTERMODE	tinyint	IN

Definition

Copy



create function dbo.UFN_WIDGETDASHBOARD_GETSTARTENDDATE
(
@STARTDATE date = null
,@ENDDATE date = null
,@SPECIFICDATE date = null 
,@FILTERMODE tinyint = 0  --0: Today mode ,1: Specific day mode, 2: Date range Start and End date

)
returns @STARTANDENDDATE table
(
      ID int identity primary key
      ,STARTDATE date
      ,ENDDATE date
)
as begin
    -- do work here and return a value

  if @FILTERMODE = 0 or (@FILTERMODE = 1 and @SPECIFICDATE is null)
  begin
        set @STARTDATE = getdate()
        set @ENDDATE = dateadd(dd,1,getdate())    
  end
  else if @FILTERMODE = 1
  begin
        set @STARTDATE = @SPECIFICDATE
        set @ENDDATE = dateadd(dd,1,@SPECIFICDATE)
  end
  else if @FILTERMODE = 2
      if @ENDDATE is not null 
          set @ENDDATE = dateadd(dd,1,@ENDDATE)    

  insert into    @STARTANDENDDATE(STARTDATE,ENDDATE)    values(@STARTDATE,@ENDDATE)

  --select STARTDATE, ENDDATE from @STARTANDENDDATE


    return
end