date filter equal to

[Bryian]

Hello,

I'm using Html.Kendo().Grid and one of the column is datetime type. The filter "is equal to" is not working. Any solution?

[Vladimir Iliev]

Hi Bryian,

The "IsEqualTo" filter is not recommended to be used for filtering of dates as the dates contains time information which is taken into consideration:

e.g.:

//This date
'2014-09-17T12:04:58.125Z'
//Is not equal to the following example date selected from the filter due to the different time parts:
'2014-09-17T00:00:00.000Z'

Possible solution is to enable the 'serverFiltering' and ignore the time part of the date when filtering the records. Another option is to use combination of ,,are later than" and ,,are earlier than".

Kind Regards,
Vladimir Iliev
Telerik