I am using a workflow to add 6 months to a date field but doesn't quite work as I intended.
ex: 28/02/2017 + 6 months = 28/08/2017 not 31/08/2017
Is there a way to have 28/02/2017+6 months = 31/08/2017
*This post is locked for comments
Kindly mark the answer as verified, if it is successfully executed.
thank you, will give it a try
Hi, the above condition can be fulfilled only through custom workflow.
DateTime StartDate = 28/02/2017;
DateTime EndDate = 28/02/2017 + 6 months (Temporary); i.e. 28/08/2017
DateTime FinalDate= new DateTime(EndDate.Year,EndDate.Month,31);
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156