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***
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.