3.2.0

Sorting Date Column in Active.Controls.Grid in 1.0

Hello,

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:
...
<result>
<statuscomments>row 1</statuscomments>
<statusactiondate>11/15/2006 01:12:36</statusactiondate>
</result>
<result>
<statuscomments>row 2</statuscomments>
<statusactiondate>11/15/2006 02:14:06</statusactiondate>
</result>
<result>
<statuscomments>row 3</statuscomments>
<statusactiondate>11/16/2006 05:46:04</statusactiondate>
</result>
<result>
<statuscomments>row 4</statuscomments>
<statusactiondate>01/02/2007 08:49:25</statusactiondate>
</result>
...

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,
MK
January 26,
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
January 27,

This topic is archived.

See also:


Back to support forum