Sort dateTime Broken in Rev 2.9?

[Sarah Reichelt]

On Sun, Apr 13, 2008 at 8:21 PM, Peter Reid <preid at reid-it.co.uk> wrote:
> Has anyone found a problem with sorting using dateTime as the sort type with
> Rev 2.9?
>
>  I have a stack which has been running OK with previous Rev releases that
> displays a table with a number of columns containing different types of data
> Some columns contain text (surnames), some contain numbers (staff IDs) and
> some contain dates (interview date). The user clicks on the column heading
> to sort the table as required, with each click reversing the direction of
> the sort ascending/descending.
>
>  With Rev 2.9, the sorting works for the text and numeric columns but not
> the date columns, which contain dates in UK format (DD/MM/YYYY).  If I step
> through in debug mode the sort command executes, but there is no change to
> the field itself.  The two sort commands I use for the date columns are as
> follows depending on the required sort order:
>
>   sort lines of field "Results" descending dateTime by item colNo of each
>   sort lines of field "Results" ascending dateTime by item colNo of each

I just did a quick test and it worked fine for me. Don't forget to set
the useSystemDate to true before sorting.
I presume you are sure the itemDelimiter is set correctly.

If it was working in a previous version, these must have already been
set, so I can't see what might be happening, but sort dateTime does
work for me with 2.9.0.

Cheers,
Sarah