Won't Fix
Last Updated: 08 Nov 2018 20:51 by ADMIN
ADMIN
Vasil
Created on: 19 Dec 2016 14:07
Category: UI for ASP.NET AJAX
Type: Feature Request
0
String representation of dates in GridDateTimeColumn is wrong in the FilterExpression when using Between filter.
The correct format should be ISO 8601:
([CreateDate] >= '2013-06-22T00.00.00') AND ([CreateDate] <= '2013-06-22T23.59.59'

Workaround: https://www.telerik.com/support/kb/aspnet-ajax/grid/details/get-sql-compliant-filterexpressions-from-radgrid
1 comment
ADMIN
Eyup
Posted on: 29 Jan 2018 09:56
This is the built-in behavior of RadGrid and it is not planned to change, because it may introduce some serious breaking changes related to the filtering functionality of the grid.

For additional information, please check the explanation provided in the following post:
https://www.telerik.com/forums/griddatetimecolumn-filtering-localization-issues#k8bwUfk7vk-NzH2ihvfo6Q