topic Addmonths() function not working properly. in QlikView

Addmonths() function not working properly.

Mon, 22 Apr 2013 15:28:22 GMT

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

Re: Addmonths() function not working properly.

Mon, 22 Apr 2013 15:28:44 GMT

Thanks for Reply

Re: Addmonths() function not working properly.

Mon, 22 Apr 2013 15:33:17 GMT

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

Re: Addmonths() function not working properly.

Mon, 22 Apr 2013 15:43:49 GMT

Try this

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

That will give you last month (-1)

Re: Addmonths() function not working properly.

Mon, 22 Apr 2013 16:04:20 GMT

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

Re: Addmonths() function not working properly.

Tue, 23 Apr 2013 12:16:48 GMT

let

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

Expected ouput: 2013-2-17

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

Re: Addmonths() function not working properly.

danielrozental — Tue, 23 Apr 2013 12:21:50 GMT

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

Re: Addmonths() function not working properly.

Tue, 23 Apr 2013 13:05:59 GMT

let

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

Expected ouput: 2013-2-17

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

Re: Addmonths() function not working properly.

Tue, 23 Apr 2013 13:12:51 GMT

yes

Re: Addmonths() function not working properly.

Tue, 23 Apr 2013 13:55:05 GMT

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

Re: Addmonths() function not working properly.

Tue, 23 Apr 2013 13:55:18 GMT

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

Re: Addmonths() function not working properly.

Tue, 23 Apr 2013 13:59:36 GMT

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

Re: Addmonths() function not working properly.

CELAMBARASAN — Tue, 23 Apr 2013 14:04:31 GMT

It is correct!

Lets take your adding one month to the date.

Mode 1 is works differently only when the given date is greater than the next month end date. otherwise it will be same as Mode 0.

Hope it helps

Celambarasan

Re: Addmonths() function not working properly.

Tue, 23 Apr 2013 15:19:15 GMT

Satti,

It is your understanding of the situation that is flawed, not the computer program

y=addmonths('2013-1-27',1,1); - gives 2/27.

y=addmonths('2013-1-28',1,1); - gives 2/25.

y=addmonths('2013-1-29',1,1); - gives 2/26.

y=addmonths('2013-1-30',1,1); - gives 2/27

y=addmonths('2013-1-31',1,1); - gives 2/28

In short, 'mode 1' functions only at the end of the month. Otherwise it functions as normal.

Re: Addmonths() function not working properly.

Wed, 24 Apr 2013 09:44:19 GMT

Hi other_people_shoes,

I got your point. You are right.

mode 1 only works for 28,29,30,31 dates.

Thanks for your explanation.

Re: Addmonths() function not working properly.

Wed, 24 Apr 2013 09:44:34 GMT

Hi other_people_shoes,

I got your point. You are right.

mode 1 only works for 28,29,30,31 dates.

Thanks for your explanation.