

Creator III
2012-08-13
10:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


MVP
2012-08-13
10:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please check the addmonths() function in the Help, I think it could look like:
Let vMaxDatePlusMonth = addmonths('$(vMaxDate)',1);
3 Replies


MVP
2012-08-13
10:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please check the addmonths() function in the Help, I think it could look like:
Let vMaxDatePlusMonth = addmonths('$(vMaxDate)',1);

Not applicable
2012-08-13
10:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LET vMaxDatePlusMonth = Addmonths($(vMaxDate),1)

Not applicable
2012-08-13
10:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
lol swuehl must have sneeked that in when I was typing
