Note that DateTime() returns an array which you are treating as a string. Recode with Year(), Month(), and Day() and then you can manipulate to produce the output that you want.
----- Original Message ----- From: "Lester Vanhoff" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Saturday, June 10, 2006 4:19 AM Subject: [amibroker] How To Get Two Digit Year In Exploration > > 1) The following exploration works ok: > > Filter = 1; > SetOption("NoDefaultColumns", True); > AddTextColumn(Name(), "Ticker"); > AddColumn( DateTime(), "Date&Time", formatDateTime ); > AddColumn( Close, "Close", 1.4 ); > AddColumn( Volume, "Volume", 1.0 ); > > 2) Now if you try to get two-digit year instead of four-digit year the > formula returns an error (the date format on my computer is set to > yyyy-mm-dd): > > /***START***/ > > Filter = 1; > > yy = StrMid(DateTime(),2,2); //start=char#2 (zero based), length=2 char > mm = StrMid(DateTime(),5,2); > dd = StrMid(DateTime(),8,2); > > SetOption("NoDefaultColumns", True); > AddTextColumn(Name(), "Ticker"); > AddColumn( DateTime(), "Date&Time", formatDateTime ); > AddTextColumn(yy+mm+dd, "yymmdd"); > > AddColumn( Close, "Close", 1.4 ); > AddColumn( Volume, "Volume", 1.0 ); > > /***END***/ > > The solution might be to place DateTimeToStr() or StrToDateTime() > somewhere there. As a non-programmer I still can't get the feel for all > those strings, numbers, arrays, etc. > > > > > > > > Please note that this group is for discussion between users only. > > To get support from AmiBroker please send an e-mail directly to > SUPPORT {at} amibroker.com > > For other support material please check also: > http://www.amibroker.com/support.html > > > Yahoo! Groups Links > > > > > > > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.394 / Virus Database: 268.8.3/360 - Release Date: 06/09/06 > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Everything you need is one click away. Make Yahoo! your home page now. http://us.click.yahoo.com/AHchtC/4FxNAA/yQLSAA/GHeqlB/TM --------------------------------------------------------------------~-> Please note that this group is for discussion between users only. To get support from AmiBroker please send an e-mail directly to SUPPORT {at} amibroker.com For other support material please check also: http://www.amibroker.com/support.html Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/amibroker/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
