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

Bug Report: Filtering Grid with Date Fields

3 Answers 38 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Geoff
Top achievements
Rank 1
Geoff asked on 04 Nov 2013, 07:05 PM
Hello,

I've noticed an issue with the filtering functionality of Date fields in the Kendo Grid. This behavior can be observed when viewing the grid demo: http://demos.kendoui.com/web/grid/remote-data.html

The sample data here has 7/3/1996 as the Order Date of the first record in the grid. If I attempt to filter the records for all orders on this date ("Is equal to" 7/3/1996), nothing appears. I would expect that at least this first record would remain. If I attempt to filter the records for all orders on 7/4/1996, the only record that appears is the first record with an order date of 7/3/1996, which is also not expected. I would expect that the second record with an order date of 7/4/1996 would appear. Similar issues occur when using the other filter types ("Is after", "Is before", etc.).

Is the dev team at Telerik aware of this issue? And is there a workaround for this short of implementing my own custom filter?

Thanks!
Geoff

3 Answers, 1 is accepted

Sort by
0
Kiril Nikolov
Telerik team
answered on 06 Nov 2013, 08:07 AM
Hi Geoff,

I was not able to reproduce the issue that you are describing. The first date in the demo is 07/04/1996 and not 07/03/1996. Please check the following screencast and tell me what I missed:

http://www.screencast.com/t/YvEShV59

Regards,
Kiril Nikolov
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0
Geoff
Top achievements
Rank 1
answered on 07 Nov 2013, 02:32 PM
Hi Kiril,

Thank you for looking into this. Something is different here - the first date in the grid that I see is still 7/3/1996.

I've attached a video file that shows what I see. This is taken from: http://demos.kendoui.com/web/grid/remote-data.html

Geoff
0
Kiril Nikolov
Telerik team
answered on 11 Nov 2013, 08:47 AM
Hi Geoff,

I have investigated the matter and found what is causing this issue. When you send the filter to the server it sends the date according to your local date, and then it re-adjusts the date according to the server's time, and this is causing the discrepancy that you observe.

We have added an example, showing how to tackle such problem, please check it out on the following link:

http://www.kendoui.com/code-library/mvc/grid/using-utc-time-on-both-client-and-server-sides.aspx

Regards,
Kiril Nikolov
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
Geoff
Top achievements
Rank 1
Answers by
Kiril Nikolov
Telerik team
Geoff
Top achievements
Rank 1
Share this question
or