Question

4
Replies
2356
Views
Dilip Kumar Nagaraj (DilipKumarN)
Areteans
Dilip Kumar Nagaraj
Areteans
GB
DilipKumarN Member since 2013 12 posts
Areteans
Posted: June 7, 2018
Last activity: June 27, 2018
Posted: 7 Jun 2018 4:48 EDT
Last activity: 27 Jun 2018 23:06 EDT
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

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

Low-Code App Development Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.