ASP.NET RadGrid with date dd/mm/yyyy hh:mm:ss

[Thomas]

Hi,

 The problem is that my date is like "31/12/2015 11:45:00" and i want be able to sorting and filtering on this date.

 Here is the code:

 

                <telerik:RadGrid ID="Grid_ID" runat="server" DataSourceID="ObjectDataSource1" GroupPanelPosition="Top" AllowSorting="true" AllowFilteringByColumn="true">
                <ClientSettings>
                    <Selecting AllowRowSelect="True" />
                </ClientSettings>
                    <MasterTableView DataSourceID="ObjectDataSource1" AutoGenerateColumns="False">
                        <Columns>
                            <telerik:GridBoundColumn DataField="Code" HeaderText="Code"></telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="Num_article" HeaderText="Num. article"></telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="Description" HeaderText="Description"></telerik:GridBoundColumn>
                            <telerik:GridDateTimeColumn DataField="Date" HeaderText="Date" DataFormatString="{0:d}" FilterDateFormat="dd/MM/yyyy"></telerik:GridDateTimeColumn>
                        </Columns>
                    </MasterTableView>
                </telerik:RadGrid>
                <asp:ObjectDataSource runat="server" ID="ObjectDataSource1" SelectMethod="SP_RECORD_GET" TypeName="DA_Record"></asp:ObjectDataSource>

 

De sorting is on "string value" and i want he sort on de DATE.

Thanks for your help.

 

 

[David]

I do not see you using the "SortExpression" attribute.  With that attribute you can display one thing but sort off another.