friday | monday | |||
part | qty | date | qty | date |
140880 | 25 | 6/20/2015 | 50 | 6/30/2015 |
140890 | 25 | 6/25/2015 | 7/15/2015 | |
140891 | 30 | 7/20/2015 | 100 | 10/15/2015 |
<tbody>
</tbody>
ex. On Friday for part 140890 there is a shipment for 6/25 but on Monday, the shipment was canceled and the next recent is not till 7/20. i want to be able to pull both the 6/25 date and the 7/15 date in on friday so i know what the next shipment is