Skip to main content
F
Frell29189474k2dv
Known Participant
November 16, 2024
Answered

count the days between two modules excluding Sundays

  • November 16, 2024
  • 2 replies
  • 485 views
var nDiffDays = "";
var dd = this.getField("data1").value;
var rd = this.getField("data2").value;
if(dd.length && rd.length)
{
var d1 = util.scand("dd/m/yy", dd);
var d2 = util.scand("dd/m/yy", rd);

 if(d1 && d2)
        nDiffDays = Math.floor((d2 - d1)/86400000) +1;
}
event.value = nDiffDays;

from this code I have to exclude Sunday, so as to have a count of the days without Sunday. Thanks

This topic has been closed for replies.
Correct answer Nesa Nurani

Try this:

var nDiffDays = 0;
var dd = this.getField("data1").value;
var rd = this.getField("data2").value;

if (dd.length && rd.length) {
 var d1 = util.scand("dd/m/yy", dd);
 var d2 = util.scand("dd/m/yy", rd);

if (d1 && d2) {
 if (d1 > d2) {
  var temp = d1;
  d1 = d2;
  d2 = temp;}
 var currentDate = new Date(d1);
 while (currentDate <= d2) {
 if (currentDate.getDay() !== 0) {
  nDiffDays++;}
  currentDate.setDate(currentDate.getDate() + 1);}}}

event.value = nDiffDays;

2 replies

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
November 16, 2024

Try this:

var nDiffDays = 0;
var dd = this.getField("data1").value;
var rd = this.getField("data2").value;

if (dd.length && rd.length) {
 var d1 = util.scand("dd/m/yy", dd);
 var d2 = util.scand("dd/m/yy", rd);

if (d1 && d2) {
 if (d1 > d2) {
  var temp = d1;
  d1 = d2;
  d2 = temp;}
 var currentDate = new Date(d1);
 while (currentDate <= d2) {
 if (currentDate.getDay() !== 0) {
  nDiffDays++;}
  currentDate.setDate(currentDate.getDate() + 1);}}}

event.value = nDiffDays;
F
Frell29189474k2dvAuthor
Known Participant
November 16, 2024

Thanks @Nesa Nurani 

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices