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)
------------------------------------------------------------------------------
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
