Question
Accenture
GB
Last activity: 27 Jun 2018 23:06 EDT
Calculate difference in business days using function in Report Definition
Hi All,
I want to have a function Alias rule to calculate difference between two dates using BusinessCalendar in Days.
I am able to achieve a direct calculation without using BusinessCalendar but how can we include BusinessCalendar in functionAlias to calculate the difference in days.
We are using oracle as a database.
Please note that java functions cannot be used in report definition and only sql functions can be used
Hi All,
I want to have a function Alias rule to calculate difference between two dates using BusinessCalendar in Days.
I am able to achieve a direct calculation without using BusinessCalendar but how can we include BusinessCalendar in functionAlias to calculate the difference in days.
We are using oracle as a database.
Please note that java functions cannot be used in report definition and only sql functions can be used
Thanks
Dilip
Pegasystems Inc.
IN
Hi Dilip,
There is no OOTB way to do it.
You have to create your own Function Alias with SQL script to deal with this.
Regards,
Ujjwal
Accenture
GB
I went with a different solution to implement this requirement
1. Create a DateTime property (PropA) which should have declare expression for it .Declare expression formula should contain the business days difference (PropA=business day difference of Prop B-PropC).. Use the property PropAin your report definition which will satisfy the requirement
Pegasystems Inc.
IN
Please go through pxDifferenceInDays Function Alias and customize as per your requirement .
There’s no OOTB way you can do it ,you have to write your own sql function to get the desired report .