Sorting of Date Column

[Ritzie]

hello All,

                 I am using a date column in rad grid I want that the sorting should take place in MM/DD/YYYY format instead it is doing sorting in DD/MM/YYYY.Do I have to set any kind of property .Plz reply soon.



Regards,
Ritzie

[Shinu]

Hello Ritzie,

Set the DateFormatString for the date column and check whether its working fine for you.

ASPX:

<telerik:GridDateTimeColumn DataField="OrderDate" HeaderText="OrderDate" UniqueName="OrderDate"
     PickerType="DatePicker" DataFormatString="{0:MM/dd/yyyy}">
</telerik:GridDateTimeColumn>

-Shinu.