Doubt in Add months

[dhavalvyas]

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

[dhavalvyas]

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

[sunny_talwar]

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[dhavalvyas]

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

[sunny_talwar]

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

[dhavalvyas]

I am applying yeartodate function

[jmvilaplanap]

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

[sunny_talwar]

The expression?