Calculate the days difference in D:H:M Format
I need to calculate the difference between the days of work object creation date and resolved date and show it in a Days:Hours:Minutes format in a report definition can anyone suggest me on this.
***Updated by moderator: Lochan to add Categories***
Pegasystems Inc.
AU
Hi Anand,
You can do like this depending on the volume RD is fetching.
1. Function Alias to get difference between dates in seconds. you can find examples pxDifferenceInMinutes, pxDifferenceInHours. Unfortunatley OOTB rules does not have difference in secounds.
2. Use control to show the value in desired format or you can do the same in function alias itself.
You can refer to OOTB reports which does it in similar way. refer to TimeElapsed-HMS. It currently refers to the property instead you can use FormatDifference function.
Thanks
Jyothi.K
Pegasystems Inc.
IN
You can use the OOTB property pyResolvedTime to get the difference between 2 dates.
Since you want a particular format to display the difference between days(Days:Hours:Minutes), you can write write a custom function that calculates the difference in days, hours and minutes and returns the values in the required format.
Pegasystems Inc.
IN
You may also write an custom SQL query and use it. Embed-UserFunction.
Below links may help you.
https://collaborate.pega.com/discussion/business-days-difference-report-definition-rule
https://docs-previous.pega.com/how-use-nested-sql-functions-report-definition-rules