On Sun, Apr 13, 2008 at 8:21 PM, Peter Reid <[EMAIL PROTECTED]> 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 _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
