[Solved] Kendo is before or equal to date not filtering

[Dan]

I am using the javascript kendo grid and applying a custom filter for the year of 2015.  This is my code

 

//Filter by Year
        $('#year').on('change', function() {
            var grid = $("#grid").data("kendoGrid");
            var val = this.value;
            var fd = new Date(val, 0, 1);
            var firstday = fd;
            var ld = new Date(val, 11, 31);
            var lastday = ld;
            grid.dataSource.filter({
                logic: "and",
                filters: [
                    { field: "CheckDate", operator: "gte", value: firstday },
                    { field: "CheckDate", operator: "lte", value: lastday }
                ]
            });
        });

 

The last date of the year is set as filter 12/31/2015. However, when the filter is applied it doesn't return any of the items with the 12/31/2015.  It returns everything else but anything with the last date of the year.

[Dimiter Topalov]

Hello Dan,

The new Date(2015, 11, 31) method will return a date object with the time set to 00:00:00 local time (based on the browser location, e.g. "Thu Dec 31 2015 00:00:00 GMT+0200 (FLE Standard Time)". If the Grid data contain dates with other times (later than 0:00), the respective data items will be filtered out by such filter. You can avoid this by passing time to the new Date() method as well, e.g.:

var ld = new Date(2015, 11, 31, 23, 59, 59);

I have prepared a simple example, illustrating the described approach:

http://dojo.telerik.com/umUpu

I hope this helps, but if I am missing something, or the issue persists, please send us a similar isolated runnable project (you can use the Kendo UI Dojo), or modify the one above until the undesired behavior can be observed, so we can inspect it further, and determine what might be causing it. Thank you in advance.

Regards,
Dimiter Topalov
Telerik by Progress