3 Replies Latest reply: Jun 10, 2014 4:21 AM by Liron Baram RSS

    Limiting Sales Orders to show on the last two weeks info

      Good day All,

       

      Please could you help me with a method to restrict sales Orders tyo show on the last two weeks.

       

      Im using ORDDATE to try do this, I have restricted them to look at last two months before but for weeks it not the same.

       

       

      (if(MonthIndex >= ( vMaxMonthIndex -1), [Order Quantity Backordered]*[Component Qty]))

      is what i used for Months.

      Thank you for any assitance you may have.