[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Difference of dates



PureBytes Links

Trading Reference Links


Hans,

here is a function I wrote to translate AMI dates into a day number:

 function ws_toDayNum( adate) 
{
strDate=NumToStr(adate,7,False);
 yr= StrToNum(StrMid(strdate,1,2));
 mo=StrToNum(StrMid(strdate,3,2));
 dy=StrToNum(StrMid(strdate,5,2));
 adj=(mo>1) +( mo>3) + (mo>5) + (mo>7) + (mo>8) + (mo>10) + (mo>12)-
((mo>2)*2);
 return  ( yr*365) +( (mo-1)*30) +dy +adj;
}

>>Note: This does not account for leap years...

Walt

--- In amibroker@xxxxxxxxxxxxxxx, "Hans" <hansib@xxxx> wrote:
> 
> Thanks,
> 
> I found it in http://www.amibroker.org/3rdparty/deDateTime.zip
> but still  date difference is listed as planned function.
> 
> any other suggestion?
> 
> thanks
> Hans
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "hairy_mug" <WSCHWARZ@xxxx> wrote:
> > 
> > Hans,
> > 
> > There is a free plugin available wich will help you; 
deDateTime.zip
> > (this is in the file area)
> > 
> > http://f2.grp.yahoofs.com/v1/sF9EQup4xap5T1-
uC11vmjRlAjTorl3YBhXjh-
> > tUNkT6DqYNnc7gaJ3JawpXgDJ7HZsXlrTXcUnHnLdM-lzoPrdo0IVNc_A/PLUGIN%
> > 20DLL/deDateTime.zip
> > 
> > --- In amibroker@xxxxxxxxxxxxxxx, "Hans" <hansib@xxxx> wrote:
> > > 
> > > Hello group,
> > > 
> > > I need to calculate difference of two dates in days.
> > > 
> > > One date is input as
> > > 
> > > 
> > > expdate = ParamDate( "Expiring date", "2005-06-03", 0 ); 
> > > 
> > > 
> > > and the other one is DateNum() function
> > > 
> > > the simple calculation difference
> > > 
> > > Timedays    = expdate-DateNum();
> > > 
> > > works only within one month.
> > > 
> > > can anyone of you group code correctly the difference?
> > > 
> > > Thanks in advance.
> > > 
> > > Hans





------------------------ Yahoo! Groups Sponsor --------------------~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/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:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/