Hi,

Could anyone help please that my grid handle Date column sort as string:

1/1/2001
2/2/2000
2/3/1989

it seems to be sorted by string value, not date but i am sure that my field is date format and i did format(myDateField,'mm/dd/yyyy') for that field too.

At my asp.net control I did:

<asp:datagrid id="DataGrid1" .......
............
<columns>
<asp:BoundColumn DataField="myDateField" SortExpression="myDateField" ReadOnly="True" HeaderText="Date" DataFormatString="{00:mm/dd/yyyy}">
</asp:BoundColumn>

Any idea???

Try using DateFormatString ="{0:d}"

Well, thank for your idea...I will try.

At this moment I already solved with a hidden "yyyy/mm/dd" formated column....and sort the grid by that hidden column whenever my "shown date" column is clicked for sorting.

Using "yyyy/mm/dd" it will be correctly sorted event when it is considered to be string.

Thanks,