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

date filter equal to

1 Answer 17 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Bryian
Top achievements
Rank 1
Bryian asked on 12 Sep 2014, 01:44 PM
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?

1 Answer, 1 is accepted

Sort by
0
Vladimir Iliev
Telerik team
answered on 17 Sep 2014, 12:10 PM
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
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
Tags
Grid
Asked by
Bryian
Top achievements
Rank 1
Answers by
Vladimir Iliev
Telerik team
Share this question
or