Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..
482 views

Open time and close time duration on change management

Hello Expert!

How can we calculate open time and close time on change management.

SM: 9.33 P3

Best Regards,
Tom
0 Likes
5 Replies
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Open time and close time duration on change management

Obviously, the system calculates those fields automatically, so I have to assume you mean something else. Can you elaborate on your need? Are you wanting some way to track when the work actually began and when the work actually ended? Or...?

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Open time and close time duration on change management

 Our requirement is simple we need to know "Open time and Close time" of the CR.. Total duration for the CR. 

Best Regards,
Tom
0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Open time and close time duration on change management

Have you tried total.time=close.time-open.time? In a formatctrl, that'd be total.time in $file=close.time in $file-open.time in $file.

0 Likes
Highlighted
Trusted Contributor.
Trusted Contributor.

Re: Open time and close time duration on change management

same problem for me, how can i achieve this need? thank you

0 Likes
Highlighted
Regular Contributor.
Regular Contributor.

Re: Open time and close time duration on change management

In cm3r format control -

1. calculation tab, put true in delete column. 

2. Create a new field in cm3r dbdict named total.time. Put the datatype as Datetime.

3. In calculation tab write total.time in $file = (close.time in $file - Open.time in $file)

Done.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.