Total Time Case Was Open

(0) Share

Report

Posted on by Community Member

I was wondering if there is already a way to easily find how long a case was open?
If there isn't an easy way is there a way to convert a date/time field to milliseconds and store it in numerical field?

*This post is locked for comments

All responses (4)

Answers (2)

Suggested answer

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: Total Time Case Was Open

Hi ,

if a case is reopened, do you want to keep on calculate the time , if yes.

You might need to create a custom Entity to store all the date and time in different record.

Refer to below video, the concept is already there, you only have to changed the checking condition ,workflow entity, and the lookup field in custom entity.
Suggested answer

Goutham A on at

Like (0)

Report

RE: Total Time Case Was Open

There is no easy one step way .I have done these kind of requirement in following way

On case status change to open , trigger a workflow which sets a custom field to current date time value.

You can display a calculated field on form.You can use DateDiff in minutes or seconds when creating this calculated field
or
You can write a custom javascript to display the date range in form(register javascript on page load)
Verified answer

gdas 50,089 on at

Like (0)

Report

RE: Total Time Case Was Open

Hello ,

Here is one simple solution using Javascript , calculate the time and put it another field .

community.dynamics.com/.../65050
Verified answer

Rawish Kumar 13,756 on at

Like (0)

Report

RE: Total Time Case Was Open

hi There,

There is no straight forward way.

However you can get something from below threads:

https://community.dynamics.com/crm/f/117/t/217663

community.dynamics.com/.../calculate-the-time-an-incident-took-to-resolve-in-microsoft-dynamics-crm-2011-using-net-or-jscript