Sorting Date mm/dd/yyyy field from an array of arrays

Question

I'm currently getting data from an API and I'm coming across a problem when trying to sort the data in the client side view, by date.

This is the data I'm receiving (about 20+ but I'm giving one example with some sample data filled in)

address: "1212 Test Ave"
address2: ""
checkNumber : ""
city: "La Grange"
country: ""
email: "[email protected]"
firstName: "John"
id: "103138"
lastName: "Dough"
middleName: ""
organization: ""
partnerId: "108765.1"
paymentAmount: "$5.00 "
paymentDate: "7/30/2015"
paymentType: "CASH"
phoneNumber: "(999)999-9999"
spouseFirstName: ""
spouseLastName: ""
spouseTitle: ""
state: "IL"
title: "Mr. & Mrs."
zipCode: "60525-2544"

There is 20+ of these in an array called "contributions". How would one sort this array by paymentDate "mm/dd/yyyy". Obviously it would be year sorted first, then month, then day.

I have seen code that somewhat does this but I'm having trouble implementing it from an array that isn't solely an array of dates.

It also does not sort the days correctly, just months/year. The years is a separate array that I pulled all the dates out of for a different purpose.

this.years.sort(function (a, b) { return a - b });

But I am trying to sort the entire array listed in the first code block by date.

If anyone could help me or guide me in the right direction, that would be a massive help!

Thanks!

Additional Information using @mplungjan method. This is the output of it all when sent through to the table.

contributions.sort(function (a, b) { return new Date(a.paymentDate).getDate() - new Date(b.paymentDate).getDate(); }); — mplungjan
– mplungjan, Commented May 21, 2018 at 15:56
It seems as if this is only sorting them by day and not by year, month, then day. However, it did help me understand how the sorting portion of specific parts of a date work. The getDate is grabbing only the current day and thats why its sorting by Day only. — Alex Liosatos
– Alex Liosatos, Commented May 21, 2018 at 16:07
That is highly unlikely assuming your date is parsable as it is. — mplungjan
– mplungjan, Commented May 21, 2018 at 16:08

mplungjan · Accepted Answer · 2018-05-21 16:35:59Z

4

The sort needs date.getTime()-date.getTime()

In this case you can leave off the getTime since it will be used anyway

var contributions = [
  {paymentDate: "9/2/2014"},
  {paymentDate: "9/7/2014"},
  {paymentDate: "10/8/2015"},
  {paymentDate: "1/9/2014"},
  {paymentDate: "3/9/2015"}
]
contributions.sort(function(a, b) {
  return new Date(a.paymentDate) - new Date(b.paymentDate)
})
console.log(contributions)

edited May 21, 2018 at 16:35

answered May 21, 2018 at 16:25

mplungjan

180k29 gold badges183 silver badges246 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lajos Arpad · Accepted Answer · 2018-05-21 16:23:29Z

1

This is an easy-to-understand solution:

for (var i = 0; i < contributions.length; i++) {
    var dateI = new Date(contributions[i].paymentDate);
    for (var j = i + 1; j < contributions.length; j++) {
        var dateJ = new Date(contributions[j].paymentDate);
        if (dateI > dateJ) {
            var aux = contributions[i];
            contributions[i] = contributions[j];
            contributions[j] = aux;
            dateI = dateJ;
        }
    }
}

If you want an already existent solution, then:

contributions.sort(function(a, b) {
    return new Date(a.paymentDate) - new Date(b.paymentDate);
});

edited May 21, 2018 at 16:23

answered May 21, 2018 at 16:02

Lajos Arpad

80.5k42 gold badges124 silver badges235 bronze badges

2 Comments

Alex Liosatos Over a year ago

Thank you, your answer is VERY informative. I can see how its working now, however from the answer someone gave above, it seems that that method with the getDate only sorts the current date. and yours gives me an error (left hand and right hand arithmatic operation must be of type 'any'. And I'd need it to sort by year then month, then day.

Lajos Arpad Over a year ago

@AlexLiosatos there were some typos in my answer. I have edited my answer. It works for me. Can you give me a sample data for contributions where my code fails to sort? Can you specify whether the first or the second approach failed? If there is a problem, we will fix it. But I will need some information to do that.

Collectives™ on Stack Overflow

Sorting Date mm/dd/yyyy field from an array of arrays

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related