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 "SortColum
> 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,
> 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 t
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 DD/MM/
rt 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 sorti
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
th 'dateTime' do nothing, the others work fine! I
get the same effect if I type the sort command into the message box
and execute it directly - sort numeric and text work fine, sort
dateTime does nothing.
Has anyone else had this problem, is it a known bug in Rev 2.9 (I'm
u
sez Timothy Miller:
>[EMAIL PROTECTED] replied:
>>Timothy Miller wrote:
>>>I just did quite a bit of haphazard troubleshooting. I isolated the
>>>problem. The short dates are all preceded by a spacebar character.
>>>If I remove the spacebar characters, the sort works correctly. This
>>>is easily
Timothy Miller wrote:
I just did quite a bit of haphazard troubleshooting. I isolated the
problem. The short dates are all preceded by a spacebar character.
If I remove the spacebar characters, the sort works correctly. This
is easily reproduced. It doesn't seem to matter whether items,
lines
bles+spaces ON.. therefore I see all the
tabs, cr's, spaces, etc that can fool me.
Jim Ault
Las Vegas
>> From: Jim Ault <[EMAIL PROTECTED]>
>> Subject: Re: sort dateTime problem
>> Newsgroups: gmane.comp.ide.revolution.user
>> Date: 2005-12-15 04:48:31 GMT (20 h
Timothy Miller wrote:
I just did quite a bit of haphazard troubleshooting. I isolated the
problem. The short dates are all preceded by a spacebar character. If I
remove the spacebar characters, the sort works correctly. This is easily
reproduced. It doesn't seem to matter whether items, lines
From: Jim Ault <[EMAIL PROTECTED]>
Subject: Re: sort dateTime problem
Newsgroups: gmane.comp.ide.revolution.user
Date: 2005-12-15 04:48:31 GMT (20 hours and 30 minutes ago)
Works here...
sort lines of cd field "schedule.2" datetime by item 2 of each
What is the itemDel set to
rmat, e.g., 12/2/04.
>
> All 2005 dates come up in correct sequence, from earliest to latest.
> However, after sorting, 2004 dates *follow* 2005 dates, instead of
> preceding them. That is not a correct sort.
>
> Am I doing something wrong?
>
> Is the sort datetime command
However, after sorting, 2004 dates *follow* 2005 dates, instead of
preceding them. That is not a correct sort.
Am I doing something wrong?
Is the sort datetime command intendend to sort dates in short date
format? Or is this a bug? (I couldn't find anything in the
documentation or bugzil
On Mon, 21 Jan 2002 yves COPPE <[EMAIL PROTECTED]> wrote:
> Here a list of date (european format).
> I've asked :
>
> sort lines of fld "whatever" dateTime
> that's the result !!
>
> 25/01/2001
> 19/04/2001
> 15/05/2001
> 13/08/2002
> 27/07/2001
> 02/03/2001
> 05/01/2001
> 12/02/2001
> 12/06/2
IL PROTECTED]>
Sent: Monday, January 21, 2002 10:01 AM
Subject: Re: sort dateTime
> >Yves,
> >Did you want those dates in a different order, or is that the order you
were
> >looking for?
> >Tommy Simmons
> >Employment Law Advisory Network, Inc.
> >www.employment
ves but it isn't the order I want (obviously)
>- Original Message -
>From: yves COPPE <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, January 21, 2002 4:10 AM
>Subject: sort dateTime
>
>
>> Hello,
>>
>> Here a list of d
Yves,
>sort lines of fld "whatever" dateTime
>that's the result !!
If all else fails, covert to seconds, sort, covert back to date.
Nelson
___
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution
, January 21, 2002 4:10 AM
Subject: sort dateTime
> Hello,
>
> Here a list of date (european format).
> I've asked :
>
> sort lines of fld "whatever" dateTime
> that's the result !!
>
> 25/01/2001
> 19/04/2001
> 15/05/2001
> 13/08/2002
> 27/0
Hello,
Here a list of date (european format).
I've asked :
sort lines of fld "whatever" dateTime
that's the result !!
25/01/2001
19/04/2001
15/05/2001
13/08/2002
27/07/2001
02/03/2001
05/01/2001
12/02/2001
12/06/2001
01/08/2002
04/05/2002
12/05/2002
11/05/2003
What is the solution ??
--
_
20 matches
Mail list logo
