Re: Sort dateTime Broken in Rev 2.9?

2008-04-14 Thread Peter Reid
Thanks for the idea, unfortunately it still doesn't work even though I've changed the sortTable handler to the following: on sortTable set the useSystemDate to true set the itemDelimiter to tab put the radioPick of group SortOrder into theOrder switch the radioPick of group SortColumn

Sort dateTime Broken in Rev 2.9?

2008-04-13 Thread Peter Reid
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

Re: Sort dateTime Broken in Rev 2.9?

2008-04-13 Thread Sarah Reichelt
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

Re: Sort dateTime Broken in Rev 2.9?

2008-04-13 Thread Peter Reid
Thanks for the feedback Sarah. After sending my previous message I too put together a simple test stack which just confirmed that dateTime doesn't work on my system! My test stack consists of a table field with three columns, the first with numbers (1, 3, 5, 7, 9), the second with letters

Re: Sort dateTime Broken in Rev 2.9?

2008-04-13 Thread Richard Gaskin
Peter Reid wrote: My test stack consists of a table field with three columns, the first with numbers (1, 3, 5, 7, 9), the second with letters (a, c, e, x, y) and the third with dates (13/1/2008, 23/2/2008, 1/1/2008, 1/4/2008, 2/2/2008). Does Rev have a way of producing a format with

Re: Sort dateTime Broken in Rev 2.9?

2008-04-13 Thread Sarah Reichelt
on preOpenStack set the useSystemDate to true send initRadio to group SortColumn send initRadio to group SortOrder end preOpenStack I'm using a Mac running OS X 10.4.11 in the UK and the test dates in the third column of the table field are all UK format dates. I think I've found

Re: Sort dateTime Broken in Rev 2.9?

2008-04-13 Thread Sarah Reichelt
Does Rev have a way of producing a format with DD/MM/? I'd thought that other than long date and internet date all other formats it handles use two-digit years. I'd love to be wrong on this one... I always set my System Prefs to use 4 digit years. Now that Rev respects those settings,