Unique: "Unique One-Step Deviation in Date Comparison"

Question

Unique: "Unique One-Step Deviation in Date Comparison"

A Little Background Information:

I am working with data points that span from the current day to 5 days ahead, in 3-hour intervals (such as 10pm, 1am, 4am, 7am...). My goal is to organize these data points into arrays sorted by date, with each array representing a single day.

Initially, I tried calculating the difference between the two date objects in terms of days by using the formula

(datapoint.getTime() - today.getTime())/ millisecondsPerDay

. However, this method did not work as intended, resulting in fractions of days.

Next, I attempted to round the results using Math.ceil() and Math.floor(), but this approach also failed because it grouped together the current day and parts of the following day (for example, 10pm + 3 hours is not on the same day, even though the difference is less than 1 day).

Then, I tried comparing the days using

let diff = tmp.getDate() - today.getDate()

However, this method presented challenges when transitioning between months. When approaching the end of the month and encountering datapoints from the next month, it produced relatively high negative values that could not be used as array indices (e.g. [0,1,2,4,5,-27]).

The Question:

How can I accurately calculate the difference between two dates in distinct day-steps while accounting for changes in months?

javascript typescript

Answer 1

Answer №1

If your timestamps are given in milliseconds, you can try this method. First, divide both timestamps by (24 * 3600 * 1000) and round down using Math.floor() to get the number of complete days. Then, subtract the target date in days from the current date in days to find the difference.

For example,

mils_in_a_day = 24 * 3600 * 1000
today_in_days = Math.floor(today_in_mils / mils_in_a_day)
target_date_in_days = Math.floor(target_date_in_days / mils_in_a_day)
difference_in_days = target_date_in_days - today_in_days

To organize the results, you can create a hash for each example like this

results = {}
results[difference_in_days] = target_date_in_days

This will give you a hash structure with keys representing the difference in days and values as arrays of original timestamps. You can then use sort() on each array to sort timestamps within the same day.

While this approach may not be the most efficient, it should help you understand the concept.

Answer 2

If your timestamps are given in milliseconds, you can try this method. First, divide both timestamps by (24 * 3600 * 1000) and round down using Math.floor() to get the number of complete days. Then, subtract the target date in days from the current date in days to find the difference.

For example,

mils_in_a_day = 24 * 3600 * 1000
today_in_days = Math.floor(today_in_mils / mils_in_a_day)
target_date_in_days = Math.floor(target_date_in_days / mils_in_a_day)
difference_in_days = target_date_in_days - today_in_days

To organize the results, you can create a hash for each example like this

results = {}
results[difference_in_days] = target_date_in_days

This will give you a hash structure with keys representing the difference in days and values as arrays of original timestamps. You can then use sort() on each array to sort timestamps within the same day.

While this approach may not be the most efficient, it should help you understand the concept.

Unique: "Unique One-Step Deviation in Date Comparison"

Answer №1

Similar questions

Combine two pieces of data from a JSON object using Angular's ng-repeat

The code within $(document).ready() isn't fully prepared

Switch between Light and Dark Modes effortlessly with just one button

Guide on utilizing automatic intellisense in a standard TextArea within a web application

Is there a way to change a .pptx document into a base64 string?

Encountering the Firebase issue with error code (auth/invalid-api-key)

Adjusting a parameter according to the width of the browser window?

What Is Preventing Fields from Being Filled in the Drop-Down Menu?

The program encountered an error with code TS2339, indicating that the property "name" cannot be found on the type "never"

Transforming vertex coordinates of a polygon using Pixi.js

Twilio Fax Reception: Blank Body Detected

What's the best way to constrain a draggable element within the boundaries of its parent using right and bottom values?

Unable to use global modules in NestJS without importing them

Tips on serializing two arrays into JSON format and incorporating them in an AJAX request

Insufficient allocation - memory overflow in loopback.js

The duration from when the Ajax request is sent to when the response is received results in

Initiating Ajax to trigger the body's onLoad event

Tips for Implementing a "Please Hold On" Progress Bar in ASP.NET

Issue: requireJS configuration is invalid

Unable to modify page property status through the Notion API