Sorting in Rad Grid

[Ritzie]

Hello All,
              I have pasted y code where I want to sort the date ,But plz tell me if any property is to be added to sort the date in MM/DD/YYYY.


<

 

telerik:GridBoundColumn SortExpression ="Act_Dt" UniqueName ="Act_Dt" DataField ="Act_Dt" HeaderText="Activity Date" ShowSortIcon="false" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Font-Bold="true">

 

<

 

HeaderStyle HorizontalAlign="Left" ></HeaderStyle>

 

<

 

ItemStyle HorizontalAlign="Left" ></ItemStyle>

 

 

</telerik:GridBoundColumn>


Regards
Ritzie

 

[Pavlina]

Hello Ritzie,

In order to achieve the desired functionality I suggest you change your code as shown bellow:
ASPX:

<telerik:GridBoundColumn SortExpression="Act_Dt" DataFormatString="{0:MM/dd/yyyy}"
                                UniqueName="Act_Dt" DataField="Act_Dt" HeaderText="Activity Date" ShowSortIcon="false"
                                ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Font-Bold="true">
                                <HeaderStyle HorizontalAlign="Left"></HeaderStyle>
                                <ItemStyle HorizontalAlign="Left"></ItemStyle>
                            </telerik:GridBoundColumn>

For more information about column formatting, please refer to the following online demo:
Column Formatting

Best wishes,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.