12 Replies Latest reply: Jun 7, 2017 4:02 PM by Mark Graham RSS

    Use dates in data to create filter

    Mark Graham

      Hi all,

       

      I have available stock of 16 for Item 'A'.

      But req. is 26.

       

      Now i want to allocate that 16 to the oldest deadline IDs.

      In this case, i want to allocate available 16 to the IDs till deadline 7/22 as they are close by- since it counts to 15.

       

       

        

      IDDeadlineITEMReq.Avail.
      17/10/2017A1.0016.00
      27/12/2017A1.0016.00
      37/15/2017A1.0016.00
      47/15/2017A1.0016.00
      57/15/2017A1.0016.00
      67/18/2017A1.0016.00
      77/18/2017A1.0016.00
      87/18/2017A1.0016.00
      97/19/2017A1.0016.00
      107/19/2017A1.0016.00
      117/20/2017A1.0016.00
      127/21/2017A1.0016.00
      137/21/2017A1.0016.00
      147/21/2017A1.0016.00
      157/22/2017A1.0016.00
      167/24/2017A2.0016.00
      177/24/2017A2.0016.00
      187/24/2017A1.0016.00
      197/24/2017A1.0016.00
      207/25/2017A2.0016.00
      217/25/2017A1.0016.00
      227/25/2017A1.0016.00
      237/26/2017A2.0016.00
      247/28/2017A1.0016.00
      257/29/2017A1.0016.00
      268/2/2017A1.00

      16.00

       

      Any help is highly appreciated!!

      Please see the attachment