sort dateTime problem

Jim Ault JimAultWins at yahoo.com
Wed Dec 14 23:48:31 EST 2005


Works here...
sort lines of cd field "schedule.2" datetime by item 2 of each

What is the itemDel set to just before this step?
Are there any delimiters in what seems to be item 1?
Is there any reason the short date is not valid?
(eg 13/4/04 does not exist)

Jim Ault
Las Vegas


On 12/14/05 4:53 PM, "Timothy Miller" <gandalf at doctorTimothyMiller.com>
wrote:
> One line of a script I'm working on goes:
> 
> sort lines of cd field "schedule.2" datetime by item 2 of each.
> 
> Each line has four items. Item 2 consists of dates in short date
> format, 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 intendend to sort dates in short date
> format? Or is this a bug? (I couldn't find anything in the
> documentation or bugzilla, but I might have overlooked it.)
> 
> I could do something like converting the short dates to seconds,
> sorting numerically, then converting seconds back to short date. I'd
> rather not, though.
> 
> 
> Thanks in advance,
> 
> 
> Tim



More information about the use-livecode mailing list