Posted: 9 May 2020 21:16 EDT 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.
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?
Posted: 9 months ago
Updated: 9 months ago
Posted: 10 May 2020 11:51 EDT Updated: 11 May 2020 8:00 EDT