Display short date with working filters

[Minh]

At the moment if you only want to display the date you set the column to be string and you set x.Date.ToShortDateString() and that works perfectly for showing short dates but the sort then breaks because the values are "strings"

 

for example it'll recognize 10/1/2015 > 1/2/2015 If the universal time setting on the machine is set to DD/MM/YYYY.

 

Are there ways to display short date string and retain the filters to work correct? 

[Dimitrina]

Hi,

You can apply a converter to the binding instead. Please keep in mind the filtering will be performed based on the property specified as DataMemberBinding. You can also refer to the documentation on Filtering.

Regards,
Dimitrina
Telerik

[Minh]

Hi,

My grid at the moment is autogenerate columns, how would a converter be implemented if I don't specify the column? 

[Dimitrina]

Hello,

You can subscribe for the AutoGeneratingColumn event and then work with e.Column.

Regards,
Dimitrina
Telerik

[Minh]

Hi,

That sounds plausible, I tried the code from http://www.telerik.com/forums/codebehind-binding-with-converter-in-c but it seems like an old post. May I ask how do I set the DataMemberBinding.