UFN_DATE_TIMEFRAME

create function dbo.UFN_DATE_TIMEFRAME(@DAYS int) 
returns nvarchar(100) 
with execute as caller
as
begin
    if @DAYS<=-61
        return '61+ days ago';
    else if @DAYS>=61
        return 'Next 61+ days';

    else if @DAYS<=-31
        return '31-60 days ago';
    else if @DAYS>=31
        return 'Next 31-60 days';

    else if @DAYS<=-8
        return '8-30 days ago';
    else if @DAYS>=8
        return 'Next 8-30 days';

    else if @DAYS<=-1
        return '1-7 days ago';
    else if @DAYS>=1
        return 'Next 1-7 days';

    return 'Today';
end;