[Solved] Grid Filter by DateTime

[Ng]

• ASP.NET MVC version - ASP.NET MVC 3
• OS - Windows XP SP3
• exact browser version - Chrome 12.0.742.122
• exact version of the Telerik product - Extensions for ASP.NET MVC Q2 2011
• preferred programming language (VB.NET or C#) - C#

There is a bug in DateTime column filtering. I perform the follow fix in source code.

telerik.grid.js - line 1148

if (typeof filter.value == 'string')
    filter.value = $t.datetime.parse({ value: filter.value, format: format }).toDate();

telerik.grid.filtering.js - line 345

if (typeof value == 'string' && value.indexOf('Date(') > -1)
    date = new Date(parseInt(value.replace(/^\/Date\((.*?)\)\/$/, '$1')));
else
    date = value;

[Atanas Korchev]

Hello Ng,

 This is a known issue which has been fixed in the latest internal build.

Regards,
Atanas Korchev
the Telerik team

[Don Cote]

has this been released yet?

[Atanas Korchev]

Hello,

 Yes the hotfix has been officially released for a few months now.

Kind regards,
Atanas Korchev
the Telerik team

[Don Cote]

I was still having issues with filtering by an exact date, since the datetime picker probably used a time of 12:00:00 and the dates in the column have times on them.

I'm using SQL 2008 so I got around it by casting to the "date" type on that end.