mongoose - Finding documents in between 2 dates with MongoDB and Moment

Question

Im trying to get documents that are on this day 11 months ago. I tried today and noticed

Start:2020-02-21T08:00:00.000Z

End: 2020-02-21T07:59:59.999Z

Sample: 2020-02-21T05:08:24.522Z -- for some reason it shows before the End date but also before Start date... I also noticed startOf("date") returns a date starting at 8AM?... Any way to do this comaprison as expected?

Code:

const elevenMthsAgoS = moment().subtract(11, "months").startOf("date");
const elevenMthsAgoE = moment().subtract(11, "months").endOf("date");

const old = await User.find(
  {
    $and: [
      { "activity.lastActive": { $gte: elevenMthsAgoS } },
      { "activity.lastActive": { $lt: elevenMthsAgoE } }
    ],
  }
);

question from:https://stackoverflow.com/questions/65850862/finding-documents-in-between-2-dates-with-mongodb-and-moment

Answer 1

Waitting for answers