Question
4
Replies
2174
Views
TCS
Posted: June 7, 2018
Last activity: June 27, 2018
Closed
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
Thanks
Dilip
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