[Solved] Filtering by date column

[Matt]

Within the grid, is it possible to filter a DateTime type field on only the date part?  If I enter (or select) or select 2/22/2012, it won't select it unless the time also matches.  Is it possible to only do the date?

Thanks,
Matt

[Dadv]

hi,

What are you using? custom binding (ajax or server) ?

[Matt]

I'm just binding it to the [View] Model, not using  AJAX or anything.

[Dadv]

If you use the inbuilt filter i don't know how to mach the clue because you send the column value.

But if you use some custom binding, you could intercept the filter date request, and change it like you want.

[Atanas Korchev]

Hi,

 This can be achieved if you are using server binding. You need to bind to the Date property of your DateTime object:

columns.Bound(o => o.OrderDate.Date);

 If you are using ajax binding however you need to implement custom binding as shown in this example.

Kind regards,
Atanas Korchev
the Telerik team

[Matt]

Hello,
When I do that, I get the following error when I try to filter on that column:

The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

Thanks,

[Atanas Korchev]

Hello,

 This seems to be a limitation of Linq to Entities (it works without a problem when using Linq to SQL). In that case your only option is to implement custom binding.

Regards,
Atanas Korchev
the Telerik team

[Alex Smitt]

Instead of binding columns.Bound(o => o.OrderDate.Date);

try columns.Bound(o => o.OrderDate);