6 Replies Latest reply: Oct 4, 2017 11:51 AM by akshata tare RSS

    Date Filter to change data

    zahid Rahim

      Dear Experts,

       

      I am making an aging report. Suppose i have 2 tables:

       

      Buckets:

      Days     Bucket

      1                 0-30

      2                 0-30

      3                 0-30

      4                 0-30

      5                 0-30

      31               31-60

      32               31-60

      33               31-60

      61               61-90

      62               61-90

      63               61-90

       

      Main_query

      TRDate                    Stock_Qty

      01-SEP-2017          10

      02-SEP-2017          20

      05-SEP-2017          30

      10-SEP-2017          40

       

      Load Script joins these two tables like below:

       

      Today()-TRDATE  = Days

       

      to get the bucket wise quantity.

       

      Now the issue is instead of a fixed Today() i want to give a date filter on front end and the then buckets should be calculated as per the date selected and data change accordingly.

       

      If this is not possible then what are the workarounds i have.

       

      Regards,

       

      Zahid Rahim