Sorting through an array of timestamps to specifically filter out entries from 'last week', 'last month', and 'last year'

Question

Sorting through an array of timestamps to specifically filter out entries from 'last week', 'last month', and 'last year'

Currently, I am working with an array of timestamps and respective values. For each timestamp, I am converting it into a date format. There is a function in place that displays the dates from oldest to newest. My goal is to calculate time frames such as last week, last month, and last year based on today's date.

const myData = [
  {timestamp: 1382086394000, value: 200},
  {timestamp: 1382086394001, value: 200},
  {timestamp: 1232131231232, value: 300},
  {timestamp: 2131231241212, value: 400},
  {timestamp: 1234124124112, value: 285},
  {timestamp: 1251251251251, value: 123},
  {timestamp: 1241241241241, value: 512},
  {timestamp: 1241241241241, value: 124},
  {timestamp: 2312312123121, value: 600},
];

This represents how the current array appears after converting the timestamps to actual dates. It's important to note that this conversion has already been done.

javascript arrays timestamp

Answer 1

Answer №1

Utilizing the functions for manipulating dates in Moment.js such as add or subtract can help with this task.

let timestamp = 1382086394000; 
console.log(moment(timestamp )) // Moment<2013-10-18T08:53:14+00:00>

// calculating the date one week after the provided timestamp
console.log(moment(timestamp ).add(1, 'w')) // Moment<2013-10-25T08:53:14+00:00>

You can use similar methods to find the date from last week, month, and year by subtracting accordingly. Moment.js handles all possible scenarios that may arise.

Answer 2

Utilizing the functions for manipulating dates in Moment.js such as add or subtract can help with this task.

let timestamp = 1382086394000; 
console.log(moment(timestamp )) // Moment<2013-10-18T08:53:14+00:00>

// calculating the date one week after the provided timestamp
console.log(moment(timestamp ).add(1, 'w')) // Moment<2013-10-25T08:53:14+00:00>

You can use similar methods to find the date from last week, month, and year by subtracting accordingly. Moment.js handles all possible scenarios that may arise.

Answer 3

Answer №2

To determine the previous year (assuming a full year from Jan 1st to Dec 31st 2020 if the current year is 2021), last month (assuming a complete month from Jan 1st to Jan 31st if the current date is February), and the past week (including the last 7 days, today included), you can follow these steps.

I prefer using a semi-open interval approach (where the end of the period is not inclusive) to avoid creating timestamps like 23:59:59.999. This means you would need to compare with < for the end point.

By utilizing getMonth()-1 or getDate()-6, you tap into the internal calculations within the date object constructor. For example, executing new Date(2021, 0, -3) will yield December 28th, 2020.

let today = new Date();
console.log(today.toLocaleString());

let lastYearStart = new Date(today.getFullYear()-1, 0, 1);
let lastYearEnd = new Date(today.getFullYear(), 0, 1);

console.log(lastYearStart.toLocaleString());
console.log(lastYearEnd.toLocaleString());


let lastMonthEnd = new Date(today.getFullYear(), today.getMonth(), 1);
let lastMonthStart = new Date(lastMonthEnd.getFullYear(), lastMonthEnd.getMonth()-1, 1);

console.log(lastMonthStart.toLocaleString());
console.log(lastMonthEnd.toLocaleString());

let lastWeekStart = new Date(today.getFullYear(), today.getMonth(), today.getDate()-6);
let lastWeekEnd = new Date(today.getFullYear(), today.getMonth(), today.getDate()+1);

console.log(lastWeekStart.toLocaleString());
console.log(lastWeekEnd.toLocaleString());

const mydata = [
  {timestamp: 1382086394000, value: 200},
  {timestamp: 1382086394001, value: 200},
  {timestamp: 1232131231232, value: 300},
  {timestamp: 2131231241212, value: 400},
  {timestamp: 1234124124112, value: 285},
  {timestamp: 1251251251251, value: 123},
  {timestamp: 1241241241241, value: 512},
  {timestamp: 1241241241241, value: 124},
  {timestamp: 2312312123121, value: 600},
];

for (let d of mydata) {
  if (d.timestamp >= lastWeekStart.getTime() && d.timestamp < lastWeekEnd.getTime())
    console.log("last week");
  else if (d.timestamp >= lastMonthStart.getTime() && d.timestamp < lastMonthEnd.getTime())
    console.log("last month");
  else if (d.timestamp >= lastYearStart.getTime() && d.timestamp < lastYearEnd.getTime())
    console.log("last year");
}

A particular timestamp may fall into all three categories, last week, last month, and last year, depending on the current date. Adjust the classification as needed (use only if instead of else if) if a timestamp could be classified under multiple categories.

Answer 4

To determine the previous year (assuming a full year from Jan 1st to Dec 31st 2020 if the current year is 2021), last month (assuming a complete month from Jan 1st to Jan 31st if the current date is February), and the past week (including the last 7 days, today included), you can follow these steps.

I prefer using a semi-open interval approach (where the end of the period is not inclusive) to avoid creating timestamps like 23:59:59.999. This means you would need to compare with < for the end point.

By utilizing getMonth()-1 or getDate()-6, you tap into the internal calculations within the date object constructor. For example, executing new Date(2021, 0, -3) will yield December 28th, 2020.

let today = new Date();
console.log(today.toLocaleString());

let lastYearStart = new Date(today.getFullYear()-1, 0, 1);
let lastYearEnd = new Date(today.getFullYear(), 0, 1);

console.log(lastYearStart.toLocaleString());
console.log(lastYearEnd.toLocaleString());


let lastMonthEnd = new Date(today.getFullYear(), today.getMonth(), 1);
let lastMonthStart = new Date(lastMonthEnd.getFullYear(), lastMonthEnd.getMonth()-1, 1);

console.log(lastMonthStart.toLocaleString());
console.log(lastMonthEnd.toLocaleString());

let lastWeekStart = new Date(today.getFullYear(), today.getMonth(), today.getDate()-6);
let lastWeekEnd = new Date(today.getFullYear(), today.getMonth(), today.getDate()+1);

console.log(lastWeekStart.toLocaleString());
console.log(lastWeekEnd.toLocaleString());

const mydata = [
  {timestamp: 1382086394000, value: 200},
  {timestamp: 1382086394001, value: 200},
  {timestamp: 1232131231232, value: 300},
  {timestamp: 2131231241212, value: 400},
  {timestamp: 1234124124112, value: 285},
  {timestamp: 1251251251251, value: 123},
  {timestamp: 1241241241241, value: 512},
  {timestamp: 1241241241241, value: 124},
  {timestamp: 2312312123121, value: 600},
];

for (let d of mydata) {
  if (d.timestamp >= lastWeekStart.getTime() && d.timestamp < lastWeekEnd.getTime())
    console.log("last week");
  else if (d.timestamp >= lastMonthStart.getTime() && d.timestamp < lastMonthEnd.getTime())
    console.log("last month");
  else if (d.timestamp >= lastYearStart.getTime() && d.timestamp < lastYearEnd.getTime())
    console.log("last year");
}

A particular timestamp may fall into all three categories, last week, last month, and last year, depending on the current date. Adjust the classification as needed (use only if instead of else if) if a timestamp could be classified under multiple categories.

Sorting through an array of timestamps to specifically filter out entries from 'last week', 'last month', and 'last year'

Answer №1

Answer №2

Similar questions

Steps for automating redirection to error pages within Nuxt

Combine multiple Line objects in THREE.js using GeometryUtils.merge

Are your Promises.all functions executing at the incorrect timing?

Utilize Electron to extract and render content from a local file into HTML code

Problem encountered while converting a string to an unsigned long integer

Contrast the NSManagedObject Array with an Array containing a different "Object" Type in Swift 2

Converting JSON data into a PHP array is not within my capabilities

The position of the scroll bar remains consistent as you navigate between different websites

I am experiencing an issue where my JavaScript code does not redirect users to the next page even

What is the best way to assign a Vue property the value of a stringified element attribute?

Similar to tabpanel's ._hide() function, how can this be implemented in C#?

Excessive notification events are currently causing a blockage in the Angular app

PHP: Calculating the frequency of identical values in a multi-dimensional array

What is the reason for Julia's inability to identify the type of an array being passed as a function argument, instead categorizing it as Any?

Sorting through an array of dates in milliseconds, extracting objects with subcategories, and dynamically displaying them on the calendar based on the specific date

Traverse through a numpy array in order to populate a python list

Ensure that all characters in a string are contained within a specified array of strings using Java

Starting the selection process using AngularJS and ng-repeat

When is the best time to assign properties to mobx domain objects?

Can an Ionic Angular app utilize multiple web workers simultaneously?