Date Filtering in Grid

[Craig]

For anyone who can help - I'm having an issue with gte and lte on dates in the the grid. It works fine if I put a date before and after one for a start/end date but it does not work if the date happens to be equal. For example I have a date 10/08/2014 I know is in my database for DateEntered but the record will only show if I set start date to 10/07/2014 and enddate to 10/09/2014. Neither of them can be 10/08/2014 - won't work that way even tho those filters imply the "or equal to" part.

Here's my script for the filters:

if ((startDate != "") && (Date.parse(startDate))) {
            datesFilter.filters.push({ field: "DateEntered", operator: "gte", value: new Date(startDate) });
        }

        if ((endDate != "") && (Date.parse(endDate))) {
            datesFilter.filters.push({ field: "DateEntered", operator: "lte", value: new Date(endDate) });
        }

        if (datesFilter.filters.length) {
            $filter.push(datesFilter);
        }

Any help would be greatly appreciated!

Thanks,
Craig

[Viktor Tachev]

Hi Craig,

By default the filter will use the date and time to apply the relevant operation. If you would like the time part to be ignored when filtering I can suggest using one of the approaches described in the following article.

• https://docs.telerik.com/kendo-ui/controls/data-management/grid/how-to/filtering/filter-by-date

Give the suggestions a try and let me know how they work for you.


Regards,
Viktor Tachev
Progress Telerik

[Craig]

Thank you Viktor - that worked perfectly!