Question

1
Replies
79
Views
Niti Solanki (NitiS22)
Vodafone

Vodafone
IN
NitiS22 Member since 2016 7 posts
Vodafone
Posted: December 18, 2020
Last activity: February 24, 2021
Posted: 18 Dec 2020 11:14 EST
Last activity: 24 Feb 2021 9:33 EST

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