Support Article
BusinessCalendar.differenceBetweenDays not working as expected
SA-34513
Summary
The Out-of-the-box(OOTB) function BusinessCalendar.differenceBetweenDays is not working as expected for European time zones.
It is always returning 0 for the difference.
Error Messages
Not Applicable
Steps to Reproduce
- Create an activity with the Property-Set method for a property equal to the following value:
- (@BusinessCalendar.differenceBetweenDays("20170331T050000.000 GMT","20170221T050000.000 GMT",true,"Europe/Helsinki") ) * 100
- Execute the activity.
- Verify the result is 0.
- Change the property value to the following value:
- (@BusinessCalendar.differenceBetweenDays("20170331T050000.000 GMT","20170221T050000.000 GMT",true,"America/Newyork") ) * 100
- Execute the activity and verify the result is now 3800.
Root Cause
A defect or configuration issue in the operating environment.
The Calendar Instance coupled to the "Europe/Helsinki" time zone was corrupted and not reflecting any business days.
Resolution
Perform the following local-change:
Re-save the problematic Calendar Instance.
Published March 17, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.