8 Replies Latest reply: Sep 28, 2016 2:35 AM by gidon david RSS

    Get data between dates

    gidon david

      Hi Guys

      I need your help to solve the customer request .

       

      enclosed is a file with data of :

      DOCDATE  date of transaction

      QUANT qty

      WARHS  no   ,

      TYPE of transaction   .

      and more

       

      I need to create SUM of QUANT  ( per WARHS  from today to  date1 - that will be given as variable   - for ex 01/09/2015

       

      I need to create SUM  of QUANT  ( per WARHS  from today to  date2 - that will be given as variable  - for ex 15/09/2015

       

      and sum of QUANT between date1 to date2  where TYPE = 'M'

       

      thanks for your help

      have a nice day .

       

      gidon