How to filter date by using kendo grid conlumnMenu.

[Daochuen]

Hello,

My MVC project used kendo grid control which contain date column.  It seems date filter does not work  - after I clicking Filter button as below Page refreshed without filter. Any suggestion? Thanks in advance.

 

 

in View:

...

 columns.Bound(model => model.HireDate).Width(120).Format("{0:yyyy/MM/dd}");

...

  .ColumnMenu(columnMenu => columnMenu.Enabled(true).Filterable(true).Sortable(false).ComponentType("modern"))

[Anton Mironov]

Hello Daochuen,

Thank you for the images, code snippets, and details provided.

The pointed issue is caused by the fact, the date in the column is actually using a time part. The filter is the date with time = 00:00:00.

In order to achieve the desired behavior, I would recommend trying the approach from the following article:

• https://docs.telerik.com/kendo-ui/knowledge-base/filter-by-date

Give a try to the approach above and let me know if further assistance is needed.

Looking forward to hearing back from you.

Kind Regards,
Anton Mironov
Progress Telerik