Support Article

BusinessCalendar.differenceBetweenDays not working as expected



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

  1. 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
  2. ​Execute the activity.
  3. Verify the result is 0.
  4. Change the property value to the following value:​​
    • (@BusinessCalendar.differenceBetweenDays("20170331T050000.000 GMT","20170221T050000.000 GMT",true,"America/Newyork") ) * 100
  5. ​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.


Perform the following local-change:

Re-save the problematic Calendar Instance.

Published March 3, 2017 - Updated March 17, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.