[Gambas-user] BUG: Problem with DateAdd function

[Werner]

On 05/12/10 00:37, Benoît Minisini wrote:
>> 2010/2/13 Benoît Minisini <gambas at ...1...>:
>>     
>>>> 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
>>>       
>> This is a reply to and old post, but I'd gone off onto other projects,
>> and am just revisiting this...
>>
>> I am currently running version 2.22.0 and am still getting the error
>> described above.  If the bug had been fixed in an earlier version, it
>> seems to have crept back in.
>>
>> My Ubuntu version is currently 10.04 LTS (Lucid Lynx)
>>
>> Thanks,
>>
>> -George
>>
>>     
> Can anyone reproduce that? 
>
> I can't. I get the correct result each time with gambas 2.22.0.
>
> ?DateAdd(cdate("1/13/2010"),gb.month,-36)
> 13/01/07
> ?DateAdd(cdate("2/28/2010"),gb.month,-37)
> 28/01/07
> ?DateAdd(cdate("3/13/2010"),gb.month,-38)
> 13/01/07
>
>   
Gambas 2.19/64 Suse11.3 locale Hong Kong:

PRINT DateAdd(CDate("2/13/2010"), gb.month, -36)
PRINT DateAdd(CDate("3/28/2010"), gb.month, -37)
PRINT DateAdd(CDate("4/13/2010"), gb.month, -38)
produces
13/02/07
28/02/07
13/02/07

whereas
PRINT DateAdd(CDate("1/13/2010"), gb.month, -36)
PRINT DateAdd(CDate("2/28/2010"), gb.month, -37)
PRINT DateAdd(CDate("3/13/2010"), gb.month, -38)
all produce an invalid date error.

Regards
Werner