:: Forum >>

Sorting Date Column in Active.Controls.Grid in 1.0


I am using ActiveWidgets version 1.0 to do the following:

I am loading xml data into an Active.Controls.Grid object. My first column is of type Date (in mm/dd/yyyy hh:mm:ss format). The problem is I can not sort the dates properly.
my xml data is the folloing:
<statuscomments>row 1</statuscomments>
<statusactiondate>11/15/2006 01:12:36</statusactiondate>
<statuscomments>row 2</statuscomments>
<statusactiondate>11/15/2006 02:14:06</statusactiondate>
<statuscomments>row 3</statuscomments>
<statusactiondate>11/16/2006 05:46:04</statusactiondate>
<statuscomments>row 4</statuscomments>
<statusactiondate>01/02/2007 08:49:25</statusactiondate>

if sort them in Ascending order the grid displays them as
row 4
row 1
row 2
row 3

the XML snippets has the correct Ascending order. How can I have them sorted in correct order.

Thanks in advance for your help,
Friday, January 26, 2007
Ooops! I have left out the status column. So the columns are displayed in the following oorders:

Action Date <=> statusactiondate
Status <=> status
Comments <=> statuscomments

The problem is with the "Action Date" column

-- MK
Saturday, January 27, 2007

This topic is archived.

Back to support forum

Forum search