Addmonths function

vikasmahajan · ‎2013-03-22

Dear All,

Can anybody explain addmonths with mode in details ?

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2013-04-22

Hello ,

I think this works only when year is leap but I am not sure

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-09-11

Hello Satti,

This is because the next month which you are adding is of 28 days. And any date before 28th of feb would return same date irrespective of mode.

Thanks,

ASINGH

michael_anthony · ‎2013-09-12

Mode 1 is only effective when the starting date is >= 28th of the month. Any earlier day returns same for both modes. This applies to all months, not just February. Presume this is because all months have at least 28 days so there is no confusion of how to add a month, whereas 28,29,30 and 31 could be interpreted differently.

Report Inappropriate Content · ‎2015-05-15

Hi Gysbert,

I need a help from you, Please help me on this :

I have 3 months date, Suppose - 1 Jan to 31 Jan, 1 Feb to 28 Feb and for March - 1 Mar 2015. Now I am in QlikView script to load this, It is reloading . But Output should to come like

Invoice Date : 31 Jan 2015, 1 Feb 2015 to 28 Feb (Whole Date for Feb Month) and no date for 1st Mar 2015.

buzzy996 · ‎2015-05-15

addmonths() --help to add/remove few months to ur current selection date.

go with reference manual for more details!

Related Topics