Question

26
Views
Close popover
Niti Solanki (NitiS22)
Vodafone

Vodafone
IN
NitiS22 Member since 2016 7 posts
Vodafone
Posted: December 18, 2020
Last activity: December 18, 2020

Business Days calculation in Report definition using function alias

Hello Team,

We have tried using below code in Function Alias and referred in Report Definition. We are getting the attached error while running the Report definition.

{1} = from_date

{2} = to_date

select count(d::date) as d from generate_series({1}, {2}, '1 day'::interval) d where extract('dow' from d) not in (0, 6)

Thanks,

Niti

***Edited by Moderator Marissa to update Platform Capability tags****
Pega Platform 8.3.2 Case Management Reporting Communications and Media