Filter csv file data by date

[logshashi (Shashi)]

Hi…

I’ve got a csv file with date data in dd/MM/yyyy format. I need to write filtered data to another csv file, only the rows with date > specified date e.g. 01/09/2018.
Data has few columns:
CL_Code, Date_Regd

The file needs to be filtered by Date_Regd
Tried few things, it’s not working out.
Any sample file/help is appreciated.

Thanks.

[nadim.warsi]

Try this:

CSV Date Filter Issue

Hi, I’m trying to filter the CSV data after a particular date. But filter is returning wrong number of records. CSV file is received through an e-mail. PFA code file. Steps I’m following are Read CSV into data table Apply filter on data table. (Date >= 2nd Nov 2017) dt.Select(“Date>='”+Convert.ToDateTime(“02/11/2017”).ToShortDateString()+" “+Convert.ToDateTime(“02/11/2017”).ToShortTimeString+”'") Store the filtered data in another excel. Date format is dd/MM/yyyy CSV Filter.zip …