Question
ATOS
IN
Last activity: 11 May 2020 8:01 EDT
difference between dates (in minutes) in Report Definition
We have a requirement where we need to display the age of a case (Difference between CreateDateTime and CurentDateTime based on business calendar) in mins in a Report. There are functions available which can do this. But the report definition only can invoke Function alias rules and there are no OOTB function alias rules available to get this done.
I have gone through some of the posts in PDN. But couldn't find a solution. one of the link which describes same issue that I have is https://collaborate.pega.com/discussion/business-days-difference-report-definition-rule, but there is no solution in this link too. Can you please suggest is there a way to do this?
***Edited by Moderator: Pallavi to change content type from Discussion to Question***
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
Use Difference in Days function and enter pxCreateDateTime as Earlier value and select CurrentDateTime by using function in the Later Date value.
Please find the below screenshot for more details.
Updated: 11 May 2020 8:00 EDT
ATOS
IN
Thanks Pavan for replying. what you have mentioned will work based on the General hours not based on business hours. Let me explain with an example, Let's say we have business hours mentioned in my calendar instance as 09:00AM to 05:00PM on all weekdays.
Lets assume a case has been created on 7th May 3PM and the case is with status Open and we are running the report at 11AM on 8th May. then the OOTB function alias(the one you have mentioned above) will give the difference as 20 hours. But what I actually looking for is, 3PM to 5PM (2 hours) + 9AM to 11AM (2 hours) = 4 hours. Is there a way to do it?
Updated: 11 May 2020 8:00 EDT
Barclays UK PLC
GB
DifferenceInDays function should do it. If that's not helpful. Create an alias for the function which is working for you. Use the alias in your RD.