This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



~Lily Ekrethernivu
Dec 21, 2014, 4:28 PM
51 Posts
topic has been resolvedResolved

Calculating working days between two dates

  • Category: Server Side JavaScript
  • Platform: Windows
  • Release: 8.5.3
  • Role: Administrator,Developer,End User
  • Tags: Calculating working days between two dates
  • Replies: 2

Dear All,

Let me know how to find working days between two days after excluding weekends and holidays in xpages.

Please help.

~Naomi Dwojumilyakoi
Dec 21, 2014, 6:09 PM
110 Posts
Evaluate the @BusinessDays

var startdate = "@Date(2014;12;1)";

var enddate = "@Date(2014;12;31)";
var weekends = "1:7"; //assuming your weekend is Saturday and Sunday
var holidays = "@Date(2014;12;24):@Date(2014;12;25)"; // assuming your holiday is 24th and 25th December
var formula = "@BusinessDays(" + startdate + ";" + enddate + ";" + weekends + ";" + holidays + ")";
return session.evaluate(formula);


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal