sorting by date senile?

xbury.cs at clearstream.com xbury.cs at clearstream.com
Wed Mar 9 10:28:16 EST 2005


>This is probably due to the dates < 1970.
>Dates from 1970 on up to 2032 will sort correctly by your syntax.

Thanks but that is rather arcane! I thought this was a modern tool ;)

There's goes another swing-around-that-sand-trap boguey!

Would using internet time or the dateitems format work better?

great! 

repeat with x = 1 to the number of lines in histo 
   convert (item 1 of line x of histo) to dateitems
 
Result = nothing! convert puts the conversion into it! ;((

a little fix for this second weird thing!

Date items now doesn't convert anything before the year 1970!

Not in the docs either! Or did I miss that? Not in the limits either!
I added a webnote to the rev docs and I guess this means a dozen
new functions in XOS to handles these correctly!

Since I suppose this wont work with the "seconds" for a "simple" numeric
sort, we now have to resort to 3 sorts, one for each date item!
Triple the inneficiency here! 6X if you use the time as a factor! ;)

This is senility before age! ;)

>You will have to do some math, but you are good at that ;-)

Im good at math - but I hate to do it for a system / person
that is supposed to do it better and faster than me!

I tried the usesystemdate but it didn't help.
I dont dare use the centurycutoff as it makes things even more confusing!
Where does the century start and stop now? 

I find this a big weakness in view of the rest of the sophistication of 
our
beloved environment! Any stats, history, listing, calendar, etc is 
affected
sooner or later! 

Any reason why this is still so primitive?

Regards,
Xavier



-----------------------------------------
Visit us at http://www.clearstream.com
IMPORTANT MESSAGE    Internet communications are not secure and therefore
Clearstream International does not accept legal responsibility for the
contents of this message.    The information contained in this e-mail is
confidential and may be legally privileged. It is intended solely for the
addressee. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it,
is prohibited and may be unlawful. Any views expressed in this e-mail are
those of the individual sender, except where the sender specifically states
them to be the views of Clearstream International or of any of its
affiliates or subsidiaries.    END OF DISCLAIMER


More information about the use-livecode mailing list