Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

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