Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

4
Replies
737
Views
 Durga Ramesh (DurgaR87) Capgemini Technology Services India Ltd
Capgemini Technology Services India Ltd
IN
DurgaR87 Member since 2019 17 posts
Capgemini Technology Services India Ltd
Posted: Dec 14, 2021
Last activity: Dec 15, 2021
Posted: 14 Dec 2021 12:52 EST
Last activity: 15 Dec 2021 4:45 EST
Closed
Solved

Day difference between two dates using business calendar in report definition

Report

Hi,

 

Can anyone suggest how to write the Function Alias to calculate the Day difference between two dates using business calendar in report definition? Our DB is MS SQL.

Or is there any other way other than function alias to achieve this?

Thanks in advance! 

***Edited by Moderator Marissa to update Capability tags****
Pega Platform 8.4.2 Reporting User Experience
Posted: 1 year ago
Posted: 15 Dec 2021 3:17 EST
Durga Ramesh (DurgaR87) Capgemini Technology Services India Ltd
Capgemini Technology Services India Ltd
IN
Report

Hi @SaurabhG7134   Thank you for your reply. I checked this link already. That is for Oracle but I'm asking for MS SQL. I cant find any working code for MS SQL to match the requirement

Accepted Solution

Posted: 1 year ago
Updated: 1 year ago
Posted: 15 Dec 2021 4:42 EST
Updated: 15 Dec 2021 4:45 EST
Nikita Kumari (NikitaK7) Capgemini India Pvt ltd
Capgemini India Pvt ltd
IN
Report

@DurgaR87  Hi Durga, for this requirement try to create a declare expression, hope this will work
Posted: 1 year ago
Posted: 15 Dec 2021 4:45 EST
Durga Ramesh (DurgaR87) Capgemini Technology Services India Ltd
Capgemini Technology Services India Ltd
IN
Report

Hi @NikitaK7   Thank you for your reply. Yes as  you said I used declare expression and referred the property into report its working. Thank you!!

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice