Trying to filter columns using the Filter Wizard however the columns are strings.
The first condition are if column A has an value less than an integer value, that the user would input. However I am unable to use the < operation given that the data in the data table is a string. Also under this column not all the values are integers.
Second condition is if the date comes before a certain date, input by the user. The date is also a string in the form yyyyMMdd.
Currently getting an error “Column type is not supported.”
I’m using the IsNumeric given not all data in the column is an integer
DateTime.ParseExact(“DATEENTRY”, “yyyyMMdd”, System.Globalization.CultureInfo.InvariantCulture)
Made a small change with your code given I was getting an error “Invariant is not a member of System.Globalization.CultureInfo”