2 Replies Latest reply: Jan 7, 2013 3:07 PM by chand S RSS

    Date Range bucket >30 days,>15 days

      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.