Tips on arranging an array based on dates and data in JavaScript?

Question

Tips on arranging an array based on dates and data in JavaScript?

I have an array with dates and other data that I need to sort based on the dates. I'm unsure of how to go about this. Can someone please assist me?

Here is the array in question:

0:{_id: "01-11-2017", CommentCount: 221, Likecount: 141, Followcount: 0, Unfollowcount: 116}
1:{_id: "27-10-2017", CommentCount: 235, Likecount: 495, Followcount: 802, Unfollowcount: 98}
2:{_id: "28-10-2017", CommentCount: 232, Likecount: 52, Followcount: 0, Unfollowcount: 799}
3:{_id: "29-10-2017", CommentCount: 236, Likecount: 52, Followcount: 0, Unfollowcount: 611}
4:{_id: "30-10-2017", CommentCount: 233, Likecount: 58, Followcount: 0,  Unfollowcount: 0}
5:{_id: "31-10-2017", CommentCount: 240, Likecount: 175, Followcount: 0, Unfollowcount: 0}

Desired output:

0:{_id: "27-10-2017", CommentCount: 235, Likecount: 495, Followcount: 802, Unfollowcount: 98}
1:{_id: "28-10-2017", CommentCount: 232, Likecount: 52, Followcount: 0, Unfollowcount: 799}
2:{_id: "29-10-2017", CommentCount: 236, Likecount: 52, Followcount: 0, Unfollowcount: 611}
3:{_id: "30-10-2017", CommentCount: 233, Likecount: 58, Followcount: 0, Unfollowcount: 0}
4:{_id: "31-10-2017", CommentCount: 240, Likecount: 175, Followcount: 0, Unfollowcount: 0}
5:{_id: "01-11-2017", CommentCount: 221, Likecount: 141, Followcount: 0, Unfollowcount: 116}

javascript arrays

Answer 1

Answer №1

To start, you must convert the date-string into an actual Date object. Once this is done, you can customize the sorting as needed:

const inputs = [
  {_id: "01-11-2017", CommentCount: 221, Likecount: 141, Followcount: 0, Unfollowcount: 116},
  {_id: "27-10-2017", CommentCount: 235, Likecount: 495, Followcount: 802, Unfollowcount: 98},
  {_id: "28-10-2017", CommentCount: 232, Likecount: 52, Followcount: 0, Unfollowcount: 799},
  {_id: "29-10-2017", CommentCount: 236, Likecount: 52, Followcount: 0, Unfollowcount: 611},
  {_id: "30-10-2017", CommentCount: 233, Likecount: 58, Followcount: 0,  Unfollowcount: 0},
  {_id: "31-10-2017", CommentCount: 240, Likecount: 175, Followcount: 0, Unfollowcount: 0}
];

const results = inputs.sort((a, b) => getDate(a._id) - getDate(b._id));

function getDate(s) {
  const parts = s.split('-');
  return new Date(parts.pop(), parts.pop() - 1, parts.pop());
}

console.log(results);

Keep in mind that this solution is only compatible with modern browsers due to the use of Arrow function.

For additional information, you can check out Arrow functions and perhaps Array pop

Answer 2

To start, you must convert the date-string into an actual Date object. Once this is done, you can customize the sorting as needed:

const inputs = [
  {_id: "01-11-2017", CommentCount: 221, Likecount: 141, Followcount: 0, Unfollowcount: 116},
  {_id: "27-10-2017", CommentCount: 235, Likecount: 495, Followcount: 802, Unfollowcount: 98},
  {_id: "28-10-2017", CommentCount: 232, Likecount: 52, Followcount: 0, Unfollowcount: 799},
  {_id: "29-10-2017", CommentCount: 236, Likecount: 52, Followcount: 0, Unfollowcount: 611},
  {_id: "30-10-2017", CommentCount: 233, Likecount: 58, Followcount: 0,  Unfollowcount: 0},
  {_id: "31-10-2017", CommentCount: 240, Likecount: 175, Followcount: 0, Unfollowcount: 0}
];

const results = inputs.sort((a, b) => getDate(a._id) - getDate(b._id));

function getDate(s) {
  const parts = s.split('-');
  return new Date(parts.pop(), parts.pop() - 1, parts.pop());
}

console.log(results);

Keep in mind that this solution is only compatible with modern browsers due to the use of Arrow function.

For additional information, you can check out Arrow functions and perhaps Array pop

Answer 3

Answer №2

Your date formatting is not compatible with JavaScript, so it is necessary to reverse it prior to passing it to the Date constructor for comparison.

console.log(arr.sort(function(a,b) {
    return new Date(a._id.split('-').reverse().join('-')).getTime() - new Date(b._id.split('-').reverse().join('-')).getTime()
}))

Following this approach will resolve the issue.

Answer 4

Your date formatting is not compatible with JavaScript, so it is necessary to reverse it prior to passing it to the Date constructor for comparison.

console.log(arr.sort(function(a,b) {
    return new Date(a._id.split('-').reverse().join('-')).getTime() - new Date(b._id.split('-').reverse().join('-')).getTime()
}))

Following this approach will resolve the issue.

Answer 5

Answer №3

To achieve the desired result, you can implement the following code snippet:

my_array.sort(function(a, b) { 
    return new Date(a._id.split("-").reverse().join("-")).getTime() - new Date(b._id.split("-").reverse().join("-")).getTime(); 
});

Explanation of the sort function:

This function is optional and allows for defining an alternative sorting order. It should return a negative, zero, or positive value based on the arguments, for example: function(a, b) { return a - b; } When the sort() method compares two values, it uses the compare function to determine the sorting order based on the returned value (negative, zero, positive).

Answer 6

To achieve the desired result, you can implement the following code snippet:

my_array.sort(function(a, b) { 
    return new Date(a._id.split("-").reverse().join("-")).getTime() - new Date(b._id.split("-").reverse().join("-")).getTime(); 
});

Explanation of the sort function:

This function is optional and allows for defining an alternative sorting order. It should return a negative, zero, or positive value based on the arguments, for example: function(a, b) { return a - b; } When the sort() method compares two values, it uses the compare function to determine the sorting order based on the returned value (negative, zero, positive).

Tips on arranging an array based on dates and data in JavaScript?

Answer №1

Answer №2

Answer №3

Similar questions

Revolutionizing Form Select Field: Introducing Rails' Dynamic Input Rendering

Difficulty with linking a CSS property to an HTML element using JavaScript

Leveraging HTML5's local storage functionality to save and manage a collection of list elements within `<ul>`

"Encountering a problem with using setState in React Hook useEffect

What is the process for obtaining the Tag from a React Component?

Bringing information from MSSQL database into a two-dimensional array

What are the steps to build a dynamic webpage in a Django project?

What is the process for configuring socket.io to solely listen on a single designated route?

Combining query results/objects by id in an array within a React application with Firebase Firestore

Retrieve only the items from a JavaScript array where the index is below a specified value

Saving data from Material UI forms in TypeScript

Use React to increment a variable by a random value until it reaches a specific threshold

Avoid receiving input for a button that is being covered by another button

Understanding how to parse an array of arrays in JavaScript can be a

What causes my slider to speed up with an increase in items and slow down with fewer items in bxslider?

Tips for handling catch errors in fetch POST requests in React Native

Analyzing the array information

Exploring Protractor testing with Bootstrap modals

The Kenburn zoom image effect fails to function

Prevent the <a> tag href attribute from functioning with jQuery