Incrementing date field by months based on a user input field(#of months to increment)
1.LastScheduledDate(a simple date only field)
2. Increment field(whole number).
3. Calculated Field "NextDate" formula is: Set NextDate to AddMonths(Increment;LastScheduledDate)
4. I have a workflow that updates LastScheduledDate so the NextDate keeps getting created.
Here are the results:
Last Scheduled Date=8/1/2018..... Next Scheduled date gets properly calculated to 10/1/2018. The increment is 2(months).
Last Scheduled Date=10/1/2018... Next Scheduled date gets improperly calculated to 11/30/2018. Expected it to be 12/1/2018.
Then all the rest of the dates are now incorrect falling on the 30th instead of the 1st.
Does anyone know how to tweek this? I like that it rolls to the next year, but the day/month is incorrect.
Day cannot be higher than 28.
Any help appreciated!!
