Date Range bucket >30 days,>15 days

[#1]

Hi Guys:

i have created a straight table, in which i have listed the Tasks as follows

Taskid ProjectManager  CreateDate

1          JEJE                 01/01/2013

2          KEKE               12/13/2012

3         SMSM               12/28/2012

4          NNN                  11/13/2012

5          BBB                  12/10/2012

This table can grow very big. With this table,users also want a list box on filter criteria.Within this result set they can filter

only for Tasks where CeateDate <30 days. Also Tasks where Create Date is <15days

They want a list box somthing like    <30 days

                                                      < 15 days

how can achieve this.

I was checking other discussions on the similar topic on the forum. Looks like i should use interval match.

Interval match can be used to match dates into Month,Quarter etc.

Never used interval match before.

Is that the right approach for my problem and how do i do it.

Thanks.

[swuehl · Accepted solution]

I would suggest creating an additional field in the script, something like this:

LOAD

     Taskkid,

     ProjectManage,

     CreateDate,

    if( today() - CreateDate < 15, '<15 days',

          if( today() - CreateDate < 30, '< 30 days' )) as DateInterval

FROM ...;

[#3]

Thanks.

This worked.

[Vijayqlik4171]

I have  field 

Invoice date    //01/01/2004-01/01/2015 range 

I want 0-100days ,

100-300days,

300-500days 

500 more