Jeff,

The way I do this is to have a hidden (width = 0) column with text based on ttoc(< datetime value >, 1). The click event of the main datetime columns then sets the sort key to the hidden column.

For complex lists (for example with multiple date and numeric columns), I store the associated sort index for each column in its tag property.

Cheers,

Andrew

>I have created a listview (v6.0) that contains datetime data. When the list is sorted on that column and if the data contains dates that span the year 2000, the list will not sort properly. For example, the following dates:
>
>11/20/1999 10:00
>01/12/2000 09:15
>01/14/2000 13:00
>
>Sort ASCENDINGly like this:
>
>01/12/2000 09:15
>01/14/2000 13:00
>11/20/1999 10:00
>
>I have tried and tried to get it to work properly. I have changed the system settings, foxpro settings, etc. But, nothing works.
>
>Any ideas?
>
>Thanks,
>
>Jeff Elmore
>jeffrey.elmore@unisys.com