That is because StrToDateTime( Datestr ) with date-only string as input, will give you "END OF DAY" date which is 23:59:59.9999999 and that is this one day more.
JScript version will give you "midnight" 0:00:00 AM beginning of the day. Best regards, Tomasz Janeczko amibroker.com ----- Original Message ----- From: "ricko8294_98" <[email protected]> To: <[email protected]> Sent: Thursday, October 22, 2009 2:31 AM Subject: [amibroker] Re: Count calendar days > Interestingly, converting the 5.27 or higher version to a function, > > function getdaystill( y, m, d ) > { > SecInDay = 60 * 60 * 24; > Datestr = NumToStr( y, 1.0, False ) + "-" + NumToStr( m, 2.0 ) + "-" + > NumToStr( d, 1.0 ); > return floor( DateTimeDiff( Now( 5 ) ) / SecInDay ) ; > } > and calling it like > > Days = getdaystill(2010,1,1); > > it returns 72 (today is Oct 21) > > while the other version (at the bottom) returns 71. > > I guess 72 includes either today or the target date. > > Rick > > --- In [email protected], "Tomasz Janeczko" <gro...@...> wrote: >> >> Hello, >> >> Alternativelly if you are using 5.27 or higher you can use AFL-only solution >> >> SecInDay = 60 * 60 * 24; >> "Calendar days from today till January 1st, 2010 = " + floor( DateTimeDiff( >> StrToDateTime("2010-01-01"), Now( 5 ) )/SecInDay ) ; >> >> >> >> Also the old code needs amendment because JScript Date() gets month as 0..11 >> (instead of 1..12) >> >> >> >> EnableScript("JScript"); >> <% >> function GetDaysTill( y, m, d ) >> { >> msecPerDay = 1000 * 60 * 60 * 24; >> >> dt = new Date( y, m-1, d, 23, 59, 59 ); >> today = new Date(); >> >> distance = dt.getTime() - today.getTime(); >> >> return Math.floor( distance/msecPerDay ); >> } >> %> >> >> sc = GetScriptObject(); >> >> "Calendar days from today till January 1st, 2010 = " + sc.GetDaysTill( 2010, >> 1, 1 ); >> >> >> Best regards, >> Tomasz Janeczko >> amibroker.com >> ----- Original Message ----- >> From: "Tomasz Janeczko" <gro...@...> >> To: <[email protected]> >> Sent: Wednesday, October 21, 2009 5:50 PM >> Subject: Re: [amibroker] re: Count calendar days >> >> >> > Hello, >> > >> > Sorry, I was writing from memory and forgot that DaysSince1900 does not >> > take arguments therefore can not be used for that >> > purpose. >> > >> > Instead use this: >> > >> > EnableScript("JScript"); >> > <% >> > function GetDaysTill( y, m, d ) >> > { >> > msecPerDay = 1000 * 60 * 60 * 24; >> > >> > dt = new Date( y, m, d, 0, 0, 0 ); >> > today = new Date(); >> > >> > distance = dt.getTime() - today.getTime(); >> > >> > return Math.floor( distance / msecPerDay ); >> > } >> > %> >> > >> > sc = GetScriptObject(); >> > >> > "Calendar days from today till January 1st, 2010 = " + sc.GetDaysTill( >> > 2010, 1, 1 ); >> > >> > Best regards, >> > Tomasz Janeczko >> > amibroker.com >> > ----- Original Message ----- >> > From: "sebastiandanconia" <sebastiandanco...@...> >> > To: <[email protected]> >> > Sent: Wednesday, October 21, 2009 5:21 PM >> > Subject: [amibroker] re: Count calendar days >> > >> > >> >> (response got mixed up with different poster) >> >> >> >> Tomasz said: "You can use DateTimeConvert in conjunction with >> >> DaysSince1900. First one will convert from string representing >> >> date to datetime format and second one will report number of days. By >> >> subtracting this and DaysSince1900 of today you will get >> >> number of calendar days till future date." >> >> >> >> Tomasz, you've never yet let me down.:) I'll give that a whirl and post >> >> the code when I get it puzzled out. >> >> >> >> >> >> Sebastian >> >> >> >> >> >> >> >> ------------------------------------ >> >> >> >> **** IMPORTANT PLEASE READ **** >> >> This group is for the discussion between users only. >> >> This is *NOT* technical support channel. >> >> >> >> TO GET TECHNICAL SUPPORT send an e-mail directly to >> >> SUPPORT {at} amibroker.com >> >> >> >> TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at >> >> http://www.amibroker.com/feedback/ >> >> (submissions sent via other channels won't be considered) >> >> >> >> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: >> >> http://www.amibroker.com/devlog/ >> >> >> >> Yahoo! Groups Links >> >> >> >> >> >> >> > >> > >> > >> > ------------------------------------ >> > >> > **** IMPORTANT PLEASE READ **** >> > This group is for the discussion between users only. >> > This is *NOT* technical support channel. >> > >> > TO GET TECHNICAL SUPPORT send an e-mail directly to >> > SUPPORT {at} amibroker.com >> > >> > TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at >> > http://www.amibroker.com/feedback/ >> > (submissions sent via other channels won't be considered) >> > >> > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: >> > http://www.amibroker.com/devlog/ >> > >> > Yahoo! Groups Links >> > >> > >> > >> > > > > > ------------------------------------ > > **** IMPORTANT PLEASE READ **** > This group is for the discussion between users only. > This is *NOT* technical support channel. > > TO GET TECHNICAL SUPPORT send an e-mail directly to > SUPPORT {at} amibroker.com > > TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at > http://www.amibroker.com/feedback/ > (submissions sent via other channels won't be considered) > > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: > http://www.amibroker.com/devlog/ > > Yahoo! Groups Links > > >
