Question
Day difference between two dates using business calendar in report definition
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!
Accepted Solution
Updated: 15 Dec 2021 4:45 EST
Capgemini India Pvt ltd
IN
@DurgaR87 Hi Durga, for this requirement try to create a declare expression, hope this will work
ING Nederland
NL
Hi @DurgaR87, please check this link: https://collaborate.pega.com/question/how-refer-business-calander-difference-days-between-function-report-definition-fieldpega#comment-693826
Capgemini Technology Services India Ltd
IN
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
Updated: 15 Dec 2021 4:45 EST
Capgemini India Pvt ltd
IN
@DurgaR87 Hi Durga, for this requirement try to create a declare expression, hope this will work
Capgemini Technology Services India Ltd
IN
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!!