[Gambas-user] BUG: Problem with DateAdd function

Benoît Minisini gambas at ...1...
Sat Feb 13 20:51:35 CET 2010


> 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




More information about the User mailing list