USP_FINANCIAL_GETDATESFORPAYMENTRANGE

Returns the dates to include in a ranged search

Parameters

Parameter	Parameter Type	Mode
@DATERANGECODE	int	IN
@STARTDATE	date	INOUT
@ENDDATE	date	INOUT

Definition

Copy




CREATE procedure dbo.USP_FINANCIAL_GETDATESFORPAYMENTRANGE (
    @DATERANGECODE int,
    @STARTDATE date output,
    @ENDDATE date output
    ) as
begin
    set nocount on;    

    if @DATERANGECODE = 0 -- All

    begin
        set @STARTDATE = '0001-01-01';
        set @ENDDATE = '9999-12-31';
    end
    else if @DATERANGECODE = 1 -- Last 30 days

    begin
        set @STARTDATE = DATEADD(day,-30,GETDATE());
        set @ENDDATE = GETDATE();
    end
    else if @DATERANGECODE = 2 -- Last 60 days

    begin
        set @STARTDATE = DATEADD(day,-60,GETDATE());
        set @ENDDATE = GETDATE();
    end
    else if @DATERANGECODE = 3 -- Last 90 days

    begin
        set @STARTDATE = DATEADD(day,-90,GETDATE());
        set @ENDDATE = GETDATE();
    end
    else if @DATERANGECODE = 4 -- Last 12 months

    begin
        set @STARTDATE = DATEADD(month,-12,GETDATE());
        set @ENDDATE = GETDATE();
    end    
end