Date Filter not working in the "Binding to remote data" Grid example

[SHAWN]

I cannot get the Date Filter to work in the "Binding to remote data" Grid example:

http://demos.kendoui.com/web/grid/remote-data.html

Demo video here:
http://screencast.com/t/5Yd6xQTw3

[Nikolay Rusev]

Hello,

Have you defined OrderDate type as in the demo as it seems to be working properly on the live demos:

schema: {
 model: {
  fields: {
   OrderDate: { type: "date" }
  }
 }
}

All the best,
Nikolay Rusev
the Telerik team

[SHAWN]

The demo video that I took, is from the http://demos.kendoui.com/web/grid/remote-data.html page on this site. 

[Nikolay Rusev]

Hello Shawn,

Seems to be working on my end:
http://screencast.com/t/8Pk3Lb2ZwNk

All the best,
Nikolay Rusev
the Telerik team

[SHAWN]

it doesn't work for me in IE, FF & Chrome 
http://screencast.com/t/8LlfcwhYK
(updated video includes all 3 browsers and images of the "About" screen for each)


interesting here is a screen print of what fiddler sees
http://screencast.com/t/XKjt5sz5VO

looks like the query is round tripping to the OData service, but no results are found...

I am puzzled....

Now I am even more confused, when I search for 7/4/1996, I get results for 7/3/1996
http://screencast.com/t/xjkV1KEoq8UZ

[Nikolay Rusev]

Hello Shawn,

The behavior is due to difference in time zone for both server and client. Hence toDate function in the demo parses the date in local format. The first item in the Grid has server date( you ca inspect the response for this) 07/04/1996, but is formatted and visualized in the column as 07/03/1996.

You can change the implementation of the toDate function such that the date is parsed as UTC dates:

function toDate(value) {
 var date = dateRegExp.exec(value);
 date = new Date(parseInt(date[1]));

 return new Date(date.getUTCFullYear(),date.getUTCMonth(),date.getUTCDate());
}

Regards,
Nikolay Rusev
the Telerik team

[SHAWN]

The revised toDate function worked like a charm, thank you. Perhaps an update to the sample would help others. Additionally it might be good to see date functions added to Kendo.