Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I have a case in one project and i want to see the amount of time in which state a task was, till it is completed. I have this field on the task entity:
When a task is set to a status "Not Started", "In Progress" or "Waiting on someone else" the fields should be calculated in hours and minutes for how long they were in this status.
Does anybody have an Idea how to implement it best? Does a calculated field help me solve this problem?
Thank you in advance!
The following is my suggestion:
1. Create a field that will hold the time at which the Status Reason was changed.
2. Create a workflow that will set this field to the current time whenever the Status Reason is altered.
3. Create a calculated field that will display the difference between the current time and the value found in the field created/set in steps 1 and 2.
Thanks for your suggestion!
I think you need the separate the two time parameter values with a comma and not a minus sign.
ie. DIFFINHOURS(NOW(), tv_timetochangestatus)
Business Applications communities