You need to set numeric date format in Windows control panel.
02 instead of Feb and 01 instead of January.
Best regards,
Tomasz Janeczko
amibroker.com
----- Original Message -----
From: "gmorlosky" <gmorlo...@yahoo.com>
To: <amibroker@yahoogroups.com>
Sent: Friday, February 06, 2009 8:58 PM
Subject: [amibroker] Re: Date Sorting seems odd in Explore
> Hi Tomasz - It was a carryover from when I wanted the date before the
> ticker. I used your code below only, and I still have an alpha sort
> of the dates.
>
> --- In amibroker@yahoogroups.com, "Tomasz Janeczko" <gro...@...>
> wrote:
>>
>> Why do you use NoDefaultColumns?
>> It does not make any sense to remove name and date (default
> columns) and then add name and date.
>>
>> Simply use:
>>
>> AddTextColumn(FullName(), "Name",1.0,IIf(BarCount-
> 1,colorGreen,colorTan),colorDefault,140);
>> AddTextColumn(MarketID(1),"Market",1.0,colorBlack,colorDefault,80);
>> AddTextColumn(SectorID(1),"Sector",1.0,colorBlack,colorDefault,80);
>> AddTextColumn(IndustryID
> (1),"Industry",1.0,colorBlack,colorDefault,80);
>>
>> Best regards,
>> Tomasz Janeczko
>> amibroker.com
>> ----- Original Message -----
>> From: "gmorlosky" <gmorlo...@...>
>> To: <amibroker@yahoogroups.com>
>> Sent: Friday, February 06, 2009 6:35 PM
>> Subject: [amibroker] Re: Date Sorting seems odd in Explore
>>
>>
>> > Hi Tomasz - Here is my code whihc is giving me a problem, which
> uses
>> > AddColumn, as suggested. AB ver 5.2
>> >
>> > // Start Add Columns
>> > //
>> > SetOption("NoDefaultColumns",True);
>> > AddTextColumn(Name(),"Name",1.0,colorBlack,colorDefault,50);
>> > AddColumn(DateTime
>> > (),"Date",formatDateTime,colorBlack,colorDefault,60);
>> > AddTextColumn(FullName(), "Name",1.0,IIf(BarCount-
>> > 1,colorGreen,colorTan),colorDefault,140);
>> > AddTextColumn(MarketID
> (1),"Market",1.0,colorBlack,colorDefault,80);
>> > AddTextColumn(SectorID
> (1),"Sector",1.0,colorBlack,colorDefault,80);
>> > AddTextColumn(IndustryID
>> > (1),"Industry",1.0,colorBlack,colorDefault,80);
>> >
>> > --- In amibroker@yahoogroups.com, "Tomasz Janeczko" <groups@>
>> > wrote:
>> >>
>> >> 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" <gmorlosky@>
>> >> To: <amibroker@yahoogroups.com>
>> >> 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 amibroker@yahoogroups.com, "gmorlosky" <gmorlosky@>
> 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
>> >> >
>> >> >
>> >> >
>> >>
>> >
>> >
>> >
>> >
>> > ------------------------------------
>> >
>> > **** 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
>> >
>> >
>> >
>>
>
>
>
>
> ------------------------------------
>
> **** 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
>
>
>
