sorting issue

[Mike]

I have several datagirds that allow sorting on two date columns. The sorting
works but its not showing the newest date first when I sort. For example

if I have dates in my column as

01/01/2008
12/01/2007
12/08/2007
02/02/2007


when I sort, I get it like
12/08/2007
12/01/2007
02/02/2007
01/01/2008


or like this:
01/01/2008
02/02/2007
12/08/2007
12/01/2007

what could be causing the sort to work as such? If I don't have a date such
as 01/01/2008, the sorting works correclty, its when the date is 01/01/2008
that its not sorting correctly. Any ideas on what may be causing this?

 

[Mark Rae [MVP]]

what could be causing the sort to work as such?

It's treating the date columns as pieces of text... This would be expected
behaviour if you are doing the sorting client-side, because it won't know
natively that the data to be sorted is a textual representation of a date
type...

How have you configured your DataGrid(s), specifically the column(s) in
question?

How are you doing the sorting?

 

[Mike]

We're doing the sorting within the datagrid_sorting() method in the code
behind. The sorting has been working correctly, its just now with the
01/01/2008 dates in there, its not sorting correctly

 

[Mark Rae [MVP]]

We're doing the sorting within the datagrid_sorting() method in the code
behind.

Please post your code...

The sorting has been working correctly, its just now with the 01/01/2008
dates in there, its not sorting correctly

Almost certainly just a coincidence...

 

[Mike]

I found it, the developer that created the stored procedures is passing all
the dates as text fields and not date fields.
I fixed it now.

 

[Mark Rae [MVP]]

I found it, the developer that created the stored procedures is passing
all the dates as text fields and not date fields.

Aha...