Skip to Content
0
Former Member
Sep 24, 2014 at 06:27 PM

MAX date from the table

21 Views

Hi All

can anyone please help me in finding the MAX date from the table.

I have data like below.

I only want to display that particular row where the NEW delivery date is higher.

Below case should show only 2 row for item 001710

000010 item should be kept as it is.

Billing
Document Billing item Sales document Sales Document
Item New Delivery
Date Cost - Comp
Code Curr Net Value -
Comp Code Curr 9043128697 000010 0021911561 000010 2014-08-12 482.16 642.88 9043128697 001710 0021911561 001710 2014-08-12 638.80 592.04 9043128697 001710 0021911561 001710 2014-08-10 638.80 592.04