Is Equal to date filter not working

[Yanesh]

Hi All,

          I am using kendo grid for reporting purpose. But in my report i am using one date column for filtering purpose. My problem is when i use isequal to date filter empty grid is showing.why ?. Actually data is available in model. I attached to file. Please look into that

[Angel Petrov]

Hi,

Most probably the time part of the DateTime value does not match. You should bear in mind that when filtering date, the data source uses DateTime not only the date part. If you want to ignore the time part you can checkout the solution suggested here. Another approach would be to use a date time picker for filtering.

Regards,
Angel Petrov
Progress Telerik

[Kojoe]

The answer to this is fairly simple. When setting your DateTime variable in your controller, simply use the ".Date" property. This will truncate the DateTime to consider only the Date portion.

DateTime DueDate => PublishDate.AddDays(29).Date;