Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

Adding one month to a date

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?

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

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

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

View solution in original post

3 Replies
swuehl
Champion III
Champion III

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

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

Not applicable

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

Not applicable

lol swuehl must have sneeked that in when I was typing