Calculating every number within a range of dates and storing them in the format of [day, hour]

Question

Calculating every number within a range of dates and storing them in the format of [day, hour]

Given two date pairs represented as numbers [hour, weekday], where hour ranges from 0-23 and weekday ranges from 1-7. I am tasked with generating all the hours in between each pair. For example, if given [13, 2] and [2, 3], the output would be:

[13,2]
[14,2]
[15,2]
...
[0,3]
[1,3]
[2,3]

I also have the dates stored as datetimes, but I'm unsure which representation to utilize for the task at hand. The time interval between the two dates is always just a few days and does not span across weeks.

javascript

Answer 1

Answer №1

If you create a function called next for determining the next date by using the modulo operator % to choose the upcoming hour and day, you can then use a basic while loop to generate all dates within a specified range:

function next([hour, day]) {
  let nextHour = (hour + 1) % 24;
  let nextDay = nextHour === 0 ? (day % 7) + 1 : day;
  return [nextHour, nextDay];
}

function range([h1, d1], [h2, d2]) {
  let res = [], ch = h1, cd = d1;
  while (ch !== h2 || cd !== d2) {
    res.push([ch, cd]);
    [ch, cd] = next([ch, cd]);
  }
  res.push([ch, cd]);
  return res;
}

console.log(range([13, 2], [2, 3]));
console.log(range([13, 7], [10, 2]));

Answer 2

If you create a function called next for determining the next date by using the modulo operator % to choose the upcoming hour and day, you can then use a basic while loop to generate all dates within a specified range:

function next([hour, day]) {
  let nextHour = (hour + 1) % 24;
  let nextDay = nextHour === 0 ? (day % 7) + 1 : day;
  return [nextHour, nextDay];
}

function range([h1, d1], [h2, d2]) {
  let res = [], ch = h1, cd = d1;
  while (ch !== h2 || cd !== d2) {
    res.push([ch, cd]);
    [ch, cd] = next([ch, cd]);
  }
  res.push([ch, cd]);
  return res;
}

console.log(range([13, 2], [2, 3]));
console.log(range([13, 7], [10, 2]));

Answer 3

Answer №2

To simplify the process, consider utilizing two Date objects instead. A potential implementation could look like this:

var start = new Date(2018, 11, 20, 13);
var end = new Date(2018, 11, 21, 3);
var timeRange = [];


while(start.getTime() <= end.getTime()) {
   timeRange.push(new Date(start.getTime()))
   start.setHours(start.getHours() + 1);
}

console.log(timeRange)

Answer 4

To simplify the process, consider utilizing two Date objects instead. A potential implementation could look like this:

var start = new Date(2018, 11, 20, 13);
var end = new Date(2018, 11, 21, 3);
var timeRange = [];


while(start.getTime() <= end.getTime()) {
   timeRange.push(new Date(start.getTime()))
   start.setHours(start.getHours() + 1);
}

console.log(timeRange)

Answer 5

Answer №3

If you want to achieve something similar, consider the following approach:

const getNewDate = (hour, day) => {
  let currentDate = new Date()
  currentDate.setHours(hour)
  currentDate.setDate(currentDate.getDate() - currentDate.getDay() + day);
  return currentDate
}
const createRange = (start, end) => {
  let [startingHour, startingDay] = start, [endingHour, endingDay] = end, result = []
  const firstDate = getNewDate(startingHour, startingDay), lastDate = getNewDate(endingHour, endingDay)

  while (firstDate < lastDate) {
    firstDate.setHours(firstDate.getHours() + 1)
    result.push([firstDate.getHours(), firstDate.getDay()])
  }
  return result
}

console.log(createRange([13, 2], [2, 3]))
console.log(createRange([11, 1], [3, 2]))

The concept involves creating two different dates and then continuously adding hours in a while loop until the start date surpasses the end date.

Answer 6

If you want to achieve something similar, consider the following approach:

const getNewDate = (hour, day) => {
  let currentDate = new Date()
  currentDate.setHours(hour)
  currentDate.setDate(currentDate.getDate() - currentDate.getDay() + day);
  return currentDate
}
const createRange = (start, end) => {
  let [startingHour, startingDay] = start, [endingHour, endingDay] = end, result = []
  const firstDate = getNewDate(startingHour, startingDay), lastDate = getNewDate(endingHour, endingDay)

  while (firstDate < lastDate) {
    firstDate.setHours(firstDate.getHours() + 1)
    result.push([firstDate.getHours(), firstDate.getDay()])
  }
  return result
}

console.log(createRange([13, 2], [2, 3]))
console.log(createRange([11, 1], [3, 2]))

The concept involves creating two different dates and then continuously adding hours in a while loop until the start date surpasses the end date.

Calculating every number within a range of dates and storing them in the format of [day, hour]

Answer №1

Answer №2

Answer №3

Similar questions

An anchor-shaped name tag with a touch of flair

Experiencing issues while attempting basic private key encryption with the Node crypto library

Manipulating Images with jQuery: Adding and Removing Images Without Affecting Text

What is the best way to add attachments to the clipboard in a Chrome extension?

What causes the consistent filling of responses in jQuery ajax?

Navigating through different components in React is made possible with React Router

Selenium Python Slider Button Element Visibility Issue

Error: Unable to assign value to property 'src' because it is null

Encountering the React Native error message "TypeError: Object(...) is not a function" while using react navigation stack

Show the text from the chosen option using jQuery with a button

Can someone explain the crazy math used in three.js?

Adding JavaScript files to a project in Ionic2 with Angular2 integration

Refreshing the access token in Linkedin's oauth does not result in extending the expiration time

How to efficiently remove duplicate items from multiple select dropdowns in Angular using ng-repeat?

Using Jquery to send json data to a webserver via Ajax (API)

Refresh Angular controller after ng-click event is triggered

Sending Parsed Information to Callback for Flexible Use

Attempting to call a nested div class in JavaScript, but experiencing issues with the updated code when implemented in

Issue: requireJS configuration is invalid

Filtering rows in JQgrid is made easy after the addition of a new record