Grid display of date yyyy-MM-ddT00:00:00 when client side binding to JSON

[Glen]

I am binding data to a RadGrid via the radclientdatasource, itself via a web api giving a JSON response, the grid binds fine and I get all the columns I need.  The issue is with the date columns appearing as 2012-03-01T00:00:00 despite having the following configured

<telerik:GridDateTimeColumn FilterControlWidth="95px" DataField="PlannedDate"  UniqueName="PlannedDate" HeaderText="Planned Date" PickerType="DatePicker" EnableRangeFiltering="true" DataFormatString="{0:yyyy-MM-dd}" DataType="System.DateTime" FilterDateFormat="{0:yyyy-MM-dd}" MinDate="2012-01-01" SortedBackColor="#CCCCCC" HtmlEncode="false" EditDataFormatString="{0:yyyy-MM-dd}">
</telerik:GridDateTimeColumn>​

Have also tried GridBoundColumn.  My JSON is coming through as "PlannedDate":"2012-03-01T00:00:00"

In addition to the display issue the column is not respecting less than / greater than date filters which makes me suspect it it just being treated as text.  Any thoughts please ?

[Konstantin Dikov]

Hi Glen,

Your assumptions are correct and it seems that you are not providing a valid Date type field to your GridDateTimeColumn. In order for the date value to be formatted it must be a Date type and that type should be specified in your RadClientDataSource scheme model:

<telerik:ClientDataSourceModelField FieldName="Date" DataType="Date" />

Additionally, with the current implementation of RadGrid, the client-side binding does not support range filtering and even if you manage to pass a Date column and format it correctly, the range filtering will not work. Following is an example for a supported column definition:

<telerik:GridDateTimeColumn FilterControlWidth="95px" DataField="Date"  UniqueName="Date" HeaderText="Date" PickerType="DatePicker" DataType="System.DateTime"  DataFormatString="{0:yyyy-MM-dd}" EnableTimeIndependentFiltering="true">
</telerik:GridDateTimeColumn>

Please excuse us for any inconvenience caused by this.



Regards,
Konstantin Dikov
Telerik