Sorting on Date field

[Rahul Khinvasara]

Hi,

    We are trying to sort Rad grid column which is date in format (mm/dd/yyyy)
We used Allow Sorting and Sorted Expression property of Grid,But it's working fine only for varchar not for date.So tell me how to solve this problem?

    Can It's posible to add one more column for date it will be visible false & when I click on my date column then sorting work according to my visible false column?

Please tell me correct way?

Thanks

[Dimo]

Hello Rahul,

Are you using a GridDateTimeColumn? Here is an example in which sorting works as expected (take a look at the second RadGrid)

http://demos.telerik.com/aspnet/prometheus/Grid/Examples/GeneralFeatures/ColumnTypes/DefaultCS.aspx


Kind regards,
Dimo
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.