Apparenly you are using TEXT column for date output (AddTextColumn) and it sorts
alphabetically. 

Instead use default date/time column or use
AddColumn with formatDateTime 

Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message ----- 
From: "gmorlosky" <[email protected]>
To: <[email protected]>
Sent: Friday, February 06, 2009 4:17 PM
Subject: [amibroker] Re: Date Sorting seems odd in Explore


>I did confirm that when sorting on date (of any coloumn that 
> generates a date) of an Explore, that it is worng.
> Descending sort looks like this:
> 30-Jan-2009
> 25-Jan-2009 
> 12-Jan-2009
> 04-Feb-2009
> 03-Feb-2009
> 
> To me it should start with the lastest Julian date and go backward.
> 
> Any ideas ???
> 
> --- In [email protected], "gmorlosky" <gmorlo...@...> wrote:
>>
>> I have an explore of 6000 stocks. I descending sort on the default 
> Date 
>> column and oddly Jan 2009 dates come before Feb 2009 dates when in 
>> descending order, although 04 Feb comes before 03 Feb, which is 
> what I 
>> expect. How does the sort determine date values ?
>>
> 
> 
> 
> 
> ------------------------------------
> 
> **** IMPORTANT ****
> This group is for the discussion between users only.
> This is *NOT* technical support channel.
> 
> *********************
> TO GET TECHNICAL SUPPORT from AmiBroker please send an e-mail directly to 
> SUPPORT {at} amibroker.com
> *********************
> 
> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> http://www.amibroker.com/devlog/
> 
> For other support material please check also:
> http://www.amibroker.com/support.html
> 
> *********************************
> Yahoo! Groups Links
> 
> 
> 

Reply via email to