topic Re: Doubt in Add months in QlikView

Doubt in Add months

dhavalvyas — Wed, 25 Nov 2020 16:16:04 GMT

I am doing functions for qilkview.

I have doubt in following add month() function.

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

I comes to know that for month 02 it adds 1 in it and returns an 3rd month but for date 28 how it returns 31 ??

Re: Doubt in Add months

sunny_talwar — Sun, 09 Jul 2017 04:08:34 GMT

You are using mode = 1 (your last parameter)

=Addmonth('2003-02-28',1,1)

Try without the extra 1:

=Addmonths(MakeDate(2003, 2, 28),1)

Re: Doubt in Add months

dhavalvyas — Sun, 09 Jul 2017 04:09:55 GMT

But I want it with mode 1 ??

Re: Doubt in Add months

dhavalvyas — Sun, 09 Jul 2017 04:11:17 GMT

Just only tell about how it returns 31 ? What logic applied here

Re: Doubt in Add months

sunny_talwar — Sun, 09 Jul 2017 04:12:13 GMT

So, unfortunately then the help specify that this is the output you are going to get

Re: Doubt in Add months

dhavalvyas — Sun, 09 Jul 2017 04:13:42 GMT

I cant understand it from help ? I didn't get any logic behind it ?

Re: Doubt in Add months

sunny_talwar — Sun, 09 Jul 2017 04:14:05 GMT

Logic is right here

Read the second line.... If the input date is the 28th or above and mode is set to 1, the function will return a date which is the same distance from the end of the month as the input date... Does it make sense?

Re: Doubt in Add months

sunny_talwar — Sun, 09 Jul 2017 04:14:54 GMT

You don't understand what this means?

"If the input date is the 28th or above and mode is set to 1, the function will return a date which is the same distance from the end of the month as the input date"

Re: Doubt in Add months

dhavalvyas — Sun, 09 Jul 2017 04:21:41 GMT

so for '20003-01-29',1,1 returns '2003-02-26' how ???

Re: Doubt in Add months

sunny_talwar — Sun, 09 Jul 2017 04:29:53 GMT

Because 29th Jan is 2 days before the end of the month (31 - 2 = 29)... same way 26th is 2 days before the end of the month in feb (28-2 = 26).... Does this make sense

If it still doesn't then I am afraid I don't have a better way to understand. Help cannot be more clear in specifying what they are doing here

"If the input date is the 28th or above and mode is set to 1, the function will return a date which is the same distance from the end of the month as the input date"

Re: Doubt in Add months

dhavalvyas — Sun, 09 Jul 2017 04:44:56 GMT

Ok Now I understand properly Thank you so much bro..

Re: Doubt in Add months

sunny_talwar — Sun, 09 Jul 2017 04:48:33 GMT

Awesome, please close the thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Re: Doubt in Add months

dhavalvyas — Sun, 09 Jul 2017 04:51:38 GMT

Bhai one more doubt in year to date,

for 1999-11-18 is question

While giving input 1998-11-18,-1 return true how it possible ?

It add one year instead of subtracting one year ??

Re: Doubt in Add months

sunny_talwar — Sun, 09 Jul 2017 04:53:13 GMT

not sure I understand your question... what is the exact expression you used?

Re: Doubt in Add months

dhavalvyas — Sun, 09 Jul 2017 05:30:52 GMT

I am applying yeartodate function

Re: Doubt in Add months

jmvilaplanap — Sun, 09 Jul 2017 11:30:58 GMT

Hi,

The mode 1 calculates the date referencing the end of the month, as you are using the last day of february, this function will return the last day of any month.

Why do you need to use mode 1?

Regards

Re: Doubt in Add months

sunny_talwar — Sun, 09 Jul 2017 13:09:53 GMT

The expression?