Filter DataTable by dates provided by user

[anmolk171 (Anmol Kumar)]

Hi @Rokko,

You can use .Net expression to filter the table based on the date just go through this thread.

Filter date along with other item in Excel

Hi All, I am facing one issue in which I need to filter the data according to some date along with other parameters. Here is the steps I have taken sysDate_LastWeek= DateTime.Now.AddDays(-7) Let say I have read the data from excel using read range and now I have the data in variable DT. Date Added is column in DT which have date DT.Select(“[Industry]” LIKE %Utilities% AND [Date Added]>= # +sysDate_LastWeek + # AND [Global Delivery] =‘Yes’).CopyToDataTable. This is how I did that but I am…

Best!
Anmol