Question
Capgemini Technology Services India Ltd
IN
Last activity: 15 Dec 2021 4:45 EST
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!
Aaseya IT Services Pvt. Ltd.
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
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!!