> I've run into a strange problem with the DateAdd function, when trying
> to subtract from the current date by months.
>
> I initially hit the problem with the following (values are hard-coded
> for clarity):
> DateAdd(cdate("2/13/2010"),gb.month,-37)
>
> It seems that any combination of Date and Interval that results in a
> date of January 2007 causes an "Invalid Date" error. For example, the
> following are all invalid:
> DateAdd(cdate("1/13/2010"),gb.month,-36)
> DateAdd(cdate("2/28/2010"),gb.month,-37)
> DateAdd(cdate("3/13/2010"),gb.month,-38)
>
> Changing the starting date or the number of intervals so as to have a
> date that falls outside the month of January 2007 works okay. It also
> works okay using periods of Year or Week that fall into those dates.
>
> =======
>
> System information:
>
> Gambas Version 2.13
> Components in project: gb.db, gb.db.form, gb.form, gb.gui, gb.settings,
> gb.vb
>
> OS: Ubuntu 9.10 Karmic Koala; Kernel 2.6.31-19-generic-pae
> GNOME 2.28.1
>
> Hardware: Intel Core 2 Duo processor (E8400)
>
The bug has been fixed in revision #2697.
Regards,
--
Benoît Minisini
------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
