Determining the minimum and maximum date in an array object

Question

I have an array object that has a date field like this

    settledDate: "12-19-2018"
    settledDate: "12-12-2018"
    settledDate: "10-19-2018"
    settledDate: "10-12-2018"

I will like to determine the minimum and maximum date in this array.

I tried this but no luck

    const maxDate = new Date(Math.max.apply(null, this.props.form.details.bulkDetailsInvoices.settledDate)); 

    const minDate = new Date(Math.min.apply(null, this.props.form.details.bulkDetailsInvoices.settledDate));

Any ideas on what I can do to make this work?

Possible duplicate of Min/Max of dates in an array?

Tom Faltesek
– Tom Faltesek

2019-09-30 20:14:48 +00:00
Commented Sep 30, 2019 at 20:14 — Tom Faltesek
– Tom Faltesek, Commented Sep 30, 2019 at 20:14

Taki · Accepted Answer · 2019-09-30 21:02:39Z

2

Sort the array by date and pick the first and the last ones :

const dates = [
  { settledDate: "12-19-2018" },
  { settledDate: "12-12-2018" },
  { settledDate: "10-19-2018" },
  { settledDate: "10-12-2018" }
];

const sorted = dates.sort((a, b) => new Date(a.settledDate) - new Date(b.settledDate));

const minDate = sorted[0];
const maxDate = sorted.reverse()[0];

console.log('maxDate : ', maxDate.settledDate);
console.log('minDate : ', minDate.settledDate);

edited Sep 30, 2019 at 21:02

answered Sep 30, 2019 at 20:15

Taki

17.7k5 gold badges28 silver badges48 bronze badges

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

2 Comments

Baba Over a year ago

I think you have this the other way round. From your console.log maxDate comes first and 10-12-2018 is not the maximum date right?

Taki Over a year ago

@user2320476 yes, i fixed the answer

Nikhil · Accepted Answer · 2019-09-30 20:24:21Z

1

Here is a linear time O(n) solution. (I didn't find any linear time solution in linked duplicate question.)

const dates = [
  { settledDate: "12-19-2018" },
  { settledDate: "12-12-2018" },
  { settledDate: "10-19-2018" },
  { settledDate: "10-12-2018" }
];

let maxDate = dates[0];
let minDate = dates[0];

dates.forEach(item => {
 if (new Date(item.settledDate) < new Date(minDate.settledDate)) {
   minDate = item;
 }
 
 if (new Date(item.settledDate) > new Date(minDate.settledDate)) {
   maxDate = item;
 }
});

console.log("minDate:", minDate);
console.log("maxDate:", maxDate);

answered Sep 30, 2019 at 20:24

Nikhil

6,68110 gold badges36 silver badges74 bronze badges

Collectives™ on Stack Overflow

Determining the minimum and maximum date in an array object

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related