Select newest record when there's a duplicate

[acdeleon (Aleo)]

How to get the newest record from a datatable? For example, I have here a table in which rows A and C matched. I need to get the recent row based on the date so the output must be.

Hello 15 Hey 6/18/2021

A	B	C	D
Hello	10	Hey	6/17/2021
Hello	15	Hey	6/18/2021

[NIVED_NAMBIAR (NIVED N)]

The basic idea would to be to sort the resultant datatable based on dates [ by descending] and extract the first row which would had latest data record

[ppr (Peter Preuss)]

looks similar (for the case more rows / groups are to handle)

Return latest date from a duplicate row

Give a try on (From d in dtData.asEnumerable Group d by k1=d(“Customer PO No”).toString.Trim, k2==d(“Part No”) into grp=Group let lr = grp.OrderBy(Function (x) CDate(x(“Planned Delivery Date”).toString.Trim)) Select lr).CopyToDataTable Maybe we have to adopt the date conversion