Hello
When using the RadFilterSqlQueryProvider and using a datetime field in the Radfilter the result of the provider.Result call is for example:
When using the RadFilterSqlQueryProvider and using a datetime field in the Radfilter the result of the provider.Result call is for example:
([date)] >= '23-11-2011 16:00:00')
For SQL however one expects:
([date)] >= CONVERT(DATETIME, '2011-11-23 16:00:00', 102))
The other providers of the Radfilter also don't give a result that could be used in a where clause of an SQL statement. Do you have a solution to this?
One would expect that a custom sqlprovider (with base class RadFilterSqlQueryProvider) would be available for e.g. ms-sql and mysql.
Thanks
Piet