Datatable.select query throwing a "Cannot perform '>=' Operation...."

excel
activities
error

#1

Hi,

Am trying to filter an excel sheet data based on two dates (start and finish) received as input from the user. Am then writing this data to a new sheet. However, getting the following error…
Cannot perform ‘>=’ operation on System.Double and System.String.

Attached is the excel file am using and the XAML file. Please help.
SatinSample.xlsx (10.5 KB)
filter2.xaml (9.0 KB)


#2

Hello Satinrr…

First of all I want to make sure you have made both the values to be compared are of same data type. Because most of these errors arise just because of type mismatch. And we have similar issue on internet here which was solved. Hope this will give you an idea to resolve your concern. Ignore if it is of no use. Cheers.

Regards…
Mansi Rao


#3

Thanks Mansi. Converting the Column data to system string helped resolve the issue.

Best,
Satin