topic Re: Adding one month to a date in QlikView

Adding one month to a date

samvile18 — Mon, 13 Aug 2012 14:12:45 GMT

Hi all,

I have the following variable in my script vMaxDate which equates to 31/07/2012. What I need to do is add another variable which is always one month ahead of this one, so far I have:

vMaxDatePlusMonth = ??

I'm a little stuck with the syntax, can anyone help please?

Re: Adding one month to a date

swuehl — Mon, 13 Aug 2012 14:17:42 GMT

Please check the addmonths() function in the Help, I think it could look like:

Let vMaxDatePlusMonth = addmonths('$(vMaxDate)',1);

Re: Adding one month to a date

Mon, 13 Aug 2012 14:18:03 GMT

LET vMaxDatePlusMonth = Addmonths($(vMaxDate),1)

Re: Adding one month to a date

Mon, 13 Aug 2012 14:18:46 GMT

lol swuehl must have sneeked that in when I was typing