Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
How to calculate a license end date based on start date, cancellation date and period (month/year).
- a clients’ starts a user license on January 5, 2019 (start date),
- the license period is set to a month (period),
- on October 12, 2019, the client has let us know that he wants to end the license (cancellation date),
- Since the period is set to a month, the first possible end date should be November 4, 2019 (license end date)
How can we calculate the license end date based on start date, cancellation date and period (month/year)?
Please make me understand the cancellation date & period in your example.
How come if a period is a month, end date would be November 4 & not November 12?
Period is like a notice period which would be applicable post cancellation date?
So end date = cancellation date + Period?
Thanks for the reply.
Period is fixed (month). So if a client starts a license (subscription) on the 2nd of January, the first possible End Date would be the 1st of February (subscription start date + subscription period).
In my previous example we've received the cancellation from the client on the 12th of October, which means that the earliest Subscription End Date is November 4 (Subscription Start Date (January 5) + Subscription Periods). I guess the easiest would be to calculate the number of months from the Subscription Start Date to the Subscription Cancellation Date and round this number up. With the number of months we can calculate the Subscription End Date from the Subscription Start Date. My main concern is how to calculate the Number of months and round these up.
Hopefully this is clear now. If not, just let me know.
So If I understand correctly, you are also calculating days for subscription periods if its not starting at 1st of the month.
What I can think of is call a plugin as soon a cancelled date is entered. You would have to have simple calculations in place for months, days, leap year & get it done. That would be simplest.
Here are some URLs:
Hope this helps!
Thanks for the reply. Since I'm not a developer, I was hoping to have this somehow arranged within the boundaries of Dynamics instead of coding. Do you have any idea if this is possible?
Sorry Marcel. I don't think the exact solution is possible via config only.
Business Applications communities