Filter wizard to select records in the data table less then current date minus 2

[Palaniyappan (Forum Leader)]

Did we try with select method on this
Kindly have a view on this thread

How to Use Select Method

Try this dt.Select("[InvoiceItem]='IT Support' AND Date > '2017-01-08'").CopyToDataTable Or this dt.AsEnumerable().Where(Function(r) r("InvoiceItem").Equals("IT Support") AND cDATE(r("Date")).ToString("yyyy-mm-dd") > CDate("2017-08-01").ToString("yyyy-mm-dd")).CopyToDataTable Or even this (From p In dt.Select Where "IT Support".Equals(p.Item("InvoiceItem")) And CDate(p.Item("Date")).ToString("yyyy-mm-dd") > CDate("2017-08-01").ToString("yyyy-mm-dd") Select p).CopyToDataTable Thanks, Prank…

Cheers @agoyal1980