sorting issue

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?

Re: sorting issue

"Mike" wrote in message
news:uILCqKFVIHA.2368@TK2MSFTNGP05.phx.gbl...

> 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?


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Re: sorting issue

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]" wrote in message
news:OL82kQFVIHA.6060@TK2MSFTNGP05.phx.gbl...
> "Mike" wrote in message
> news:uILCqKFVIHA.2368@TK2MSFTNGP05.phx.gbl...
>
>> 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?
>
>
> --
> Mark Rae
> ASP.NET MVP
> http://www.markrae.net

Re: sorting issue

"Mike" wrote in message
news:%23pIVFTFVIHA.5264@TK2MSFTNGP02.phx.gbl...

>> How are you doing the sorting?
>
> 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...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Re: sorting issue

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]" wrote in message
news:OXcGcWFVIHA.3364@TK2MSFTNGP03.phx.gbl...
> "Mike" wrote in message
> news:%23pIVFTFVIHA.5264@TK2MSFTNGP02.phx.gbl...
>
>>> How are you doing the sorting?
>>
>> 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...
>
>
> --
> Mark Rae
> ASP.NET MVP
> http://www.markrae.net

Re: sorting issue

"Mike" wrote in message
news:eMyL$aFVIHA.536@TK2MSFTNGP06.phx.gbl...

> "Mark Rae [MVP]" wrote in message
> news:OXcGcWFVIHA.3364@TK2MSFTNGP03.phx.gbl...
>> "Mike" wrote in message
>> news:%23pIVFTFVIHA.5264@TK2MSFTNGP02.phx.gbl...
>>
>>>> How are you doing the sorting?
>>>
>>> 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...
>
> I found it, the developer that created the stored procedures is passing
> all the dates as text fields and not date fields.

Aha... :-)


--
Mark Rae
ASP.NET MVP
http://www.markrae.net