Day difference between two dates using business calendar in report definition

User Experience
, ,
1

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!

2

Hi @DurgaR87, please check this link: https://collaborate.pega.com/question/how-refer-business-calander-difference-days-between-function-report-definition-fieldpega#comment-693826

3

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

4

@DurgaR87 Hi Durga, for this requirement try to create a declare expression, hope this will work

5

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!!