Hello everyone ,
I'm trying to calculate the duration for each SLA KPI instance in Dynamics 365 ,
so we have the created on date and succeeded on date , and i can calculate the duration without excluding weekends and holidays
I already tried this solution , but i think it's calculating (Saturday and Sunday ) as weekends and it's giving 0 as a result most of times :
Any ideas ?
THANKS .
*This post is locked for comments
Hi Bipin, could you please provide the link for this solution.
You're welcome! I just realized the link attached to my first reply doesn't work. Here's the complete link:
Hi,
Thanks for sharing,
Hi, I know this question was posted three years, and just recently I had a similar challenge. After looking at the different entities involved, I wrote a plug-in that calculates the total number of hours and minutes spent against the SLA. The code I posted here can be a good start.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (