Select newest record when there's a duplicate

[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