Question
Accenture Services Pvt. Ltd.
IN
Last activity: 9 Nov 2022 7:01 EST
How to calculate difference between two dates with business calendar?
Unable to calculate the difference between business days even by using the business calendar function
(Pega-RULES:BusinessCalendar).differenceBetweenDates(.EDate,.SDate,true,CalendarName)+1)
(Pega-RULES:BusinessCalendar).differenceBetweenDays(.EDate,.SDate,true,CalendarName)+1)
* Please find the below are the scenario's
Scenario-1: (Not working)
startDate:03-04-2021(Saturday)
endDate:06-04-2021(Tuesday)
Expected difference is 2 days
But the return value is 3days
Scenario-2(Working Fine)
startDate:04-04-2021(Sunday)
endDate:06-04-2021(Tuesday)
Expected difference is 2 days
and the return value is 2 days
Scenario-3(Working Fine)
startDate:05-04-2021(Monday)
endDate:06-04-2021(Tuesday)
Expected difference is 2 days
and the return value is 2 days
Capgemini Technology Services India Ltd
IN
@Sreenivasulu Reddy Thank you knowledge sharing. BTW is it possible to do the same by report definition through function Alias? If you know, please share that
Best Regards,
Durga.
IQZ Systems LLC
US
Hi @Sreenivasulu Reddy, Please verify in the calendar that Saturday is unmarked for Business
Avensys Consulting Pte Ltd
SG
I have similar issues. I was using the USDefault calendar.
Seems more buggy when a Monday is selected as the start date. possible to check the implementation?
Also, do you know of a count for the number of business days in the range inclusive of both the start and end days?
Thank you
Avensys Consulting Pte Ltd
SG
@BusinessCalendar.differenceBetweenDates(.EndDate,.StartDate,true,USDefault)
Further elaboration of cases:
| StartDate | EndDate | Day | return | correct |
|---|---|---|---|---|
| 5 Dec 2022 | 5 Dec 2022 | Mon | 0 | 0 |
| 6 Dec 2022 | Tue | 0 | 1 | |
| 7 Dec 2022 | Wed | 1 | 2 | |
| 8 Dec 2022 | Thu | 2 | 3 | |
| 9 Dec 2022 | Fri | 3 | 4 | |
| 10 Dec 2022 | Sat | 4 | 5 | |
| 11 Dec 2022 | Sun | 5 | 5 | |
| 12 Dec 2022 | Mon | 5 | 5 | |
| 13 Dec 2022 | Tue | 5 | 6 | |
| 14 Dec 2022 | Wed | 6 | 7 |
@BusinessCalendar.differenceBetweenDates(.EndDate,.StartDate,true,USDefault)
Further elaboration of cases:
| StartDate | EndDate | Day | return | correct |
|---|---|---|---|---|
| 5 Dec 2022 | 5 Dec 2022 | Mon | 0 | 0 |
| 6 Dec 2022 | Tue | 0 | 1 | |
| 7 Dec 2022 | Wed | 1 | 2 | |
| 8 Dec 2022 | Thu | 2 | 3 | |
| 9 Dec 2022 | Fri | 3 | 4 | |
| 10 Dec 2022 | Sat | 4 | 5 | |
| 11 Dec 2022 | Sun | 5 | 5 | |
| 12 Dec 2022 | Mon | 5 | 5 | |
| 13 Dec 2022 | Tue | 5 | 6 | |
| 14 Dec 2022 | Wed | 6 | 7 |
| StartDate | EndDate | Day | return | correct |
|---|---|---|---|---|
| 4 Dec 2022 | 4 Dec 2022 | Sun | 0 | 0 |
| 5 Dec 2022 | Mon | 0 | 0 | |
| 6 Dec 2022 | Tue | 0 | 1 | |
| 7 Dec 2022 | Wed | 1 | 2 | |
| 8 Dec 2022 | Thu | 2 | 3 | |
| 9 Dec 2022 | Fri | 3 | 4 | |
| 10 Dec 2022 | Sat | 4 | 5 | |
| 11 Dec 2022 | Sun | 5 | 5 | |
| 12 Dec 2022 | Mon | 5 | 5 | |
| 13 Dec 2022 | Tue | 5 | 6 | |
| 14 Dec 2022 | Wed | 6 | 7 |
| StartDate | EndDate | Day | return | correct |
|---|---|---|---|---|
| 6 Dec 2022 | 6 Dec 2022 | Tue | 0 | 0 |
| 7 Dec 2022 | Wed | 1 | 1 | |
| 8 Dec 2022 | Thu | 2 | 2 | |
| 9 Dec 2022 | Fri | 3 | 3 | |
| 10 Dec 2022 | Sat | 4 | 4 | |
| 11 Dec 2022 | Sun | 5 | 4 | |
| 12 Dec 2022 | Mon | 5 | 4 | |
| 13 Dec 2022 | Tue | 5 | 5 | |
| 14 Dec 2022 | Wed | 6 | 6 |
* Correct is assuming time is 00:00.