I have an excel which contains ‘General’ type column called ‘Posting Time’ where the data in “dd-MM-yyyy HH:mm:ss” format. I just need data which posted after 4PM that means to filter out rows where the Posting Time is greater than 16:00:00.
Here I have attached a sample screen shot of my worksheet. Really appreciate your help on this.
I tried this by changing .ToArray into .CopyToDataTable (Since there was a type mismatching issue from 1-dimentional array assigning into datatable). But this gave me an error saying “Conversion from string “25-04-2022 17:45:24” to type ‘Date’ is not valid.”