2 Replies Latest reply: Jul 17, 2014 9:14 AM by Balraj Prabhu RSS

    Script doesn't filter records when I try to filter by dates ?

    Balraj Prabhu

       

      Hello,

       

       

      I''m trying to filter records that are older than jan 01 2013 in the script dynamically i.e. conceptually something like filter sale_date > = year(today()-1),

       

      Let vMaxdate  =Year (today);
      table:

      LOAD

      *
      FROM


      [New folder\fact_SalesOrder_Line_Extracted.qvd]
      (
      qvd

      )
      where  year  (sales_order_date) >= $(vMaxdate) -1;


      exit script

      ;

       

       

      My requirements are as follows:

       

      I do not want to hard code 01/01/2013 in the script , it has to be dynamic.The dashboard  shows  data from this year and last year.

       

      It has to be neat and elegant  and has to be done in the script editor and not front end.

       

      Balraj