Question
3
Replies
126
Views
CNO Services LLC
Posted: July 2, 2020
Last activity: July 5, 2020
Calculate difference in business days using function alias in Report Definition.
Hi All,
I want to have a function Alias rule to calculate difference between two dates using BusinessCalendar in Days, so that I can refer function alias in report definition. Kindly let us know if anyone has implemented the same scenario so that it will be helpful to us.
Thanks, Vijay
***Edited by Moderator: Pallavi to update platform capability tags***
Posted: 8 months ago
Updated: 8 months ago
Hi,
Can i get function alias code that you used for calculating business days. We would like to follow the same approach.
Thanks,
Vijay
Posted: 8 months ago
Hello Vijay,
Hope this link helps in creating the custom alias function in report definition.
There is no OOTB function alias to do this. The difficulty is that business days have to take into account holidays.
If this is a SQL function alias, in the past I have done this by manually maintaining a database table containing holidays that a function alias can use to exclude them as business days.