Summing the total days between two dates within an array

Question

Summing the total days between two dates within an array

My goal is to determine the number of days between two dates stored in an array.

For example:

StartDate = new Array("08 Feb 1954", "16 Sep 1955", "25 Nov 1955",
                      "19 Oct 1956", "13 Jun 1958", "08 Aug 1958", 
                      "05 Sep 1958", "02 Jan 1959", "19 Jun 1959", 
                      "07 Aug 1959", "03 Nov 1959", "11 Dec 1959", 
                      "15 Apr 1960", "20 May 1960", "21 Oct 1960", 
                      "11 Nov 1960", "20 Dec 1960");

EndDate   = new Array("26 Aug 1955", "28 Oct 1955", "07 Sep 1956",
                      "23 Nov 1956", "25 Jul 1958", "22 Aug 1958",
                      "07 Nov 1958", "17 Apr 1959", "31 Jul 1959",
                      "02 Oct 1959", "04 Dec 1959", "25 Dec 1959",
                      "13 May 1960", "10 Jun 1960", "04 Nov 1960",
                      "18 Nov 1960", "14 Feb 1961");

for ( var i = 0; (i < 17); i++ )
{
     numdays = date_diff_indays(StartDate[i], EndDate[i]);
     TotalDays += numdays;
}

I am exploring how to transform the StartDate and EndDate arrays into a multidimensional array for calculations.

Here is my current calculation approach:

var date_diff_indays = function (date1, date2) 
dt1 = new Date(date1);
dt2 = new Date(date2);
return Math.floor((Date.UTC(dt2.getFullYear(), dt2.getMonth(), dt2.getDate()) - 
                   Date.UTC(dt1.getFullYear(), dt1.getMonth(),dt1.getDate())) / (1000 * 60 * 60 * 24))

How can I iterate through the array to find the days between the dates and sum them up for a total count of days?

javascript arrays

Answer 1

Answer №1

Utilize a custom function, like calculateDates, to handle all the necessary calculations for you. In this scenario, its purpose is to determine the number of days between two specified dates.

Next, iterate through your array of startDates and invoke the function within the loop.

Use totalDays += days to keep track of and calculate the overall total number of days.

var calculateDates = function(date1, date2) {
  var dt1 = new Date(date1);
  var dt2 = new Date(date2);
  return Math.floor((Date.UTC(dt2.getFullYear(), dt2.getMonth(), dt2.getDate()) - Date.UTC(dt1.getFullYear(), dt1.getMonth(), dt1.getDate())) / (1000 * 60 * 60 * 24));
}

var startDate = ["10 Jan 1982", "05 Mar 1990", "28 Dec 2001"];
var endDate = ["25 Jan 1982", "06 Mar 1990", "02 Jan 2002"];

var totalDays = 0;

for (var i = 0; i < startDate.length; i++) {
  var days = calculateDates(startDate[i], endDate[i]);
  console.log("Number of days between", startDate[i], "and", endDate[i], "is", days);
  totalDays += days; 
}

console.log("Total number of days:", totalDays);

Answer 2

Utilize a custom function, like calculateDates, to handle all the necessary calculations for you. In this scenario, its purpose is to determine the number of days between two specified dates.

Next, iterate through your array of startDates and invoke the function within the loop.

Use totalDays += days to keep track of and calculate the overall total number of days.

var calculateDates = function(date1, date2) {
  var dt1 = new Date(date1);
  var dt2 = new Date(date2);
  return Math.floor((Date.UTC(dt2.getFullYear(), dt2.getMonth(), dt2.getDate()) - Date.UTC(dt1.getFullYear(), dt1.getMonth(), dt1.getDate())) / (1000 * 60 * 60 * 24));
}

var startDate = ["10 Jan 1982", "05 Mar 1990", "28 Dec 2001"];
var endDate = ["25 Jan 1982", "06 Mar 1990", "02 Jan 2002"];

var totalDays = 0;

for (var i = 0; i < startDate.length; i++) {
  var days = calculateDates(startDate[i], endDate[i]);
  console.log("Number of days between", startDate[i], "and", endDate[i], "is", days);
  totalDays += days; 
}

console.log("Total number of days:", totalDays);

Summing the total days between two dates within an array

Answer №1

Similar questions

What steps can be taken to make sure that my Ajax request has completed before executing a new function within the window.onload event

Modifying the default value setting in MUI Datepicker

unable to assign value to `visibility` or `display` properties

Error in Next.js: Trying to destructure an undefined object in useContext

Having trouble with your jQuery code not loading properly?

Utilizing orbital mechanics for a celestial system visualization in Three.js with coordinates (x,y,z) for planetary bodies

axios replicates the URL within the interceptor

Is there a quick way in ES6 to assign member functions as event listeners?

Running tasks in the background with Express.js after responding to the client

Sending an array as an extra in an Android intent

Invoke a "local" function inside module.exports in Node.js

Node.js server crashes upon automatic startup but remains stable when started manually

Using jQuery to access OSM data through Overpass API: A step-by-step guide

Generating a pool of p_threads

Efficiently passing multiple files with Rails using jQuery/Ajax and API

Numpy Error: Incompatible shapes for broadcasting operands (1,99) and (100,)

Ways to prevent horizontal scrolling in an image

Is there a way to apply a blur effect to a div with the contentEditable attribute set

Can someone explain how to implement an onclick event for a div element inside an iframe using jquery or javascript?

Leveraging Selenium for testing Polymer components and shadow DOM structures