AddMonths Date Function

[#1]

Hi,

Any one pls explain how it will calculate internally and display the result..

what is mode -- 1 , how it will consider

addmonths ('2003-01-29',3,1) returns '2003-04-28'

addmonths ('2003-01-29',1,1) returns '2003-02-26'

addmonths ('2003-02-28',1,1) returns '2003-03-31'

Thanks in advance..

Sub2u

[robert_mika]

addmonths ('2003-01-29',3,1) returns '2003-04-28'

January has 31 days an we are at 29 of January adding 3 months give us 28 of April

Whereas

addmonths ('2003-01-29',3,0)

will return :

'2003-04-29'

exactly 3 months after 29 of january

Same for

addmonths ('2003-01-29',1,1) returns '2003-02-26'

January has 31 days and February 28 so two days from End of month.

and

addmonths ('2003-02-28',1,1) returns '2003-03-31'