This is a migrated thread and some comments may be shown as answers.

telerik grid cannot perform '=' operation on system.datetime and string

1 Answer 328 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Sphengle
Top achievements
Rank 1
Sphengle asked on 16 Jun 2009, 11:18 AM
telerik grid cannot perform '=' operation on system.datetime and string

I get this error as a popup message when trying to filter on a date field.  From the filter drop down menu I choose "Exactly the same".  However the other options give a similar error message.

The underlying field type is DateTime

Sphengle 

1 Answer, 1 is accepted

Sort by
0
Sphengle
Top achievements
Rank 1
answered on 16 Jun 2009, 02:38 PM

Solved.  This was due to a "globalization" problem.  As a UK developer I was trying dates like 17/7/2008 which failed.  However, dates like 7/7/2008 or 7/17/2008 worked.

As soon as I added the following to the web.config the problem was resolved.

 

<globalization uiCulture="en" culture="en-GB"/>

Tags
Grid
Asked by
Sphengle
Top achievements
Rank 1
Answers by
Sphengle
Top achievements
Rank 1
Share this question
or