Addmonths() function not working properly.

[#1]

   Hi Community,

I have tried many examples to understand Addmonths() function. when i tried Examples which were mentioned in the reference manua , i got exact output.

But when i tried other examples with different modes , output is same.

Can any one explain What is the issue????

let x=addmonths('2012-1-20',1,0);     -----> 20-2-2012

let y=addmonths('2012-1-20',1,1);  ---->20-2-2012

Please explain , why two outputs are same Even modes are different????

[#2]

Thanks for Reply 

[#3]

Because you dont need the last node..

Addmonths(2012-1-20,1) gives you 2012-02-20 // NextMonth

Addmonths(2012-1-20,0) will give you the same // SameMonth

Addmonths(2012-1.20,-1) vil give you 2012-12,20 // PreviousMonth

Ofcause with '' around date

If your smart you will make a ThisDate variable

LET ThisDate = date(Today(), 'YYYY-MM-DD')

LET PreviousMonth = Addmonths(ThisDate,-1)

For an example

[#4]

Try this

=date(addmonths(Date,-1),'DD\MM\YYYY')

That will give you last month (-1)

[#5]

Mode is only used when the day for the date passed should be relative to the the day it ends up in

If you do AddMonths('2013-02-28', 1, 0) the function will return '2013-03-28' using the datepart from called month.

But if you use AddMonths('2013-02-28', 1, 1) it uses the relative date (28 being the last day of february) to set the last date of march wich is '2013-03-31'

This calculation is only performed when the day-part of the called date is >= the day-part of the resulting date OR vice versa. Usually day 28-31.

Cheers

[#6]

let

y=addmonths('2013-1-20',1,1);

Expected ouput: 2013-2-17  

but i got output : 2013-2-20 ... is it correct ????

[danielrozental]

Yes, that is the correct output. Please check the help.

[#8]

let

y=addmonths('2013-1-20',1,1);

Expected ouput: 2013-2-17  

but i got output : 2013-2-20 ... is it correct ????

[#9]

yes

[#10]

Hi Daniel ,

but i got output : 2013-2-20 ... is it correct ????

As per qlikview help it is wrong.

I have used mode 1.

Please execute it once then you will understand ..