Sort array of objects by date in dd/mm/yyyy HH:mm:ss format

Question

I have a large array of objects with a string type date field with format dd/mm/yyyyy HH:mm:ss and I can't reorder it properly.

The array looks like this

cases[
   {
      name: a, 
      date:03/04/2020 17:24:17
   },
   {
      name: b, 
      date:04/05/2020 07:21:19
   },
   {
      name: c, 
      date:02/01/2020 11:35:50
   },
]

And I tried to reorder it in the following way but without results

cases.sort(function(a,b){
                   var dateA=new Date(a.date), dateB=new Date(b.date)
                   return dateA - dateB
        });

`new Date()` won't work with `dd/MM` format. Search for how to parse dates with dd/MM to date object in javascript. You can use [moment](https://momentjs.com/) or build a simple parser like this: https://stackoverflow.com/a/38593735/3082296 — adiga, Dec 04 '20 at 12:10
returns me the dates as if the format was mm/dd/yyyy I think, without even considering the time — Lorenzo Colombo, Dec 04 '20 at 12:11
@mplungjan i need this format i can't convert it in another one — Lorenzo Colombo, Dec 04 '20 at 12:13

score 0 · Answer 1 · answered Dec 04 '20 at 12:31

Try this

cases = [{
  name: "a",
  date: "03/04/2020 17:24:17"
}, {
  name: "b",
  date: "04/05/2020 07:21:19"
}, {
  name: "c",
  date: "02/01/2020 11:35:50"
}, ]

const makeDate = str => {
  const [_, dd, mm, yyyy, hh, min, ss] = str.match(/(\d{2})\/(\d{2})\/(\d{4}) (\d{2}):(\d{2}):(\d{2})/);
  return new Date(yyyy, mm - 1, dd, hh, min, ss)
};

cases.sort((a, b) => makeDate(a.date) - makeDate(b.date))

console.log(cases)

Sort array of objects by date in dd/mm/yyyy HH:mm:ss format

1 Answers1