DataTable has date values in the format :7/25/2019 12:00:00 AM
Date value being searched is of the format:7/25/2019
In FilterDataTable the column 3 contains the date values. Using ‘contains’ does not find the searched Date value.
But if i use ‘if’ condition to check if the date string is present it returns ‘true’
csvData.Rows(3).Item(3).ToString.Contains(dateVal) --> this works
Using FilterDataTable does not pull up any data. Please let me know if there is a way to use filterDataTable to pull up rows of only a particular date.