USP_APPCATALOG_GETNEWFEATURESTARTENDDATES

create procedure dbo.USP_APPCATALOG_GETNEWFEATURESTARTENDDATES
(            
@SHOWCODE smallint = 0,
@STARTDATE datetime = NULL output,
@ENDDATE datetime = NULL output
)
as

set nocount on;

declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();

if @SHOWCODE in (1,2,3,4,5,6) begin
    set @ENDDATE = dbo.UFN_DATE_GETLATESTTIME(@CURRENTDATE);

    if @SHOWCODE = 1 --Last 30 days

        set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,-29,@CURRENTDATE));
    else if @SHOWCODE = 2 --Last 60 days

        set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,-59,@CURRENTDATE));
    else if @SHOWCODE = 3 --Last 90 days

        set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,-89,@CURRENTDATE));
    else if @SHOWCODE = 4 --Last 6 months

        set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,1,dateadd(month,-6,@CURRENTDATE)));
    else if @SHOWCODE = 5 --Last year

        set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,1,dateadd(year,-1,@CURRENTDATE)));
    else if @SHOWCODE = 6 --Last 5 years

        set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(dateadd(day,1,dateadd(year,-5,@CURRENTDATE)));
end
else if @SHOWCODE = 0 begin
    set @STARTDATE = null;
    set @ENDDATE = null;
end
else if @SHOWCODE = 99 begin
    set @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(@STARTDATE);
    set @ENDDATE = dbo.UFN_DATE_GETLATESTTIME(@ENDDATE);
end

return 0;