I am using CSV file as input and writing to Excel file.
how to filter the records from the datable based on the date condition.My format of date in my file is MM/DD/YYYY
I am using the condition as follows: bookdata.Select(“Published_Date >= #11/30/2017#” ).
But it is picking up all the records.Can anyone help on this?
below is the data from my CSV file.
Author_name Book_name Price Published_Date
Vikas Tamil book 25 10/25/2017
cavendish Maths book 50 11/1/2017
SAP Science book 23 11/12/2017
Pearson Malay book 19 12/5/2017
Marshal History book 30 9/1/2017
Peason Science book 40 9/10/2017