Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
250
Date column not getting sorted
posted

I have an ultrawebgrid with some columns as date column.

I have the columns datatype as datetime and the format is "MM/dd/yyyy"

But i am not able to sort correctly

e.g it sorts as string and not by column type.

This is the html for column

<igtbl:UltraGridColumn BaseColumnName="Date" Key="Date" Width="110px"
                                    AllowUpdate="No" DataType="System.DateTime" Format="MM/dd/yyyy">
                                    <Header Caption="Date">
                                        <RowLayoutColumnInfo OriginX="5" />
                                    </Header>
                                    <Footer>
                                        <RowLayoutColumnInfo OriginX="5" />
                                    </Footer>
                                </igtbl:UltraGridColumn> 

Please suggest