Datagrid sort date column as string

[mkhmer]

Hi,

Anyone know how to handle date column sort in grid? it seem to be sorted as
string now that result below is shown:

1/1/2006
1/2/1980
2/4/1981

I did formate the column field using "{00:mm/dd/yyyy}" and original field in
table is also a date type too.

Appreciate your kindly help on this issue....

 

[Bruno Alexandre]

it doesn't matter the string format, because the grid will sort the data by
SortExpression

so all you need to do is add the SortExpression="yourDateField" to your item
template or boundfield