Question 116388 in Mongodb Question posted in
The official documentation can be found here.

Search mongodb data using the lt & gt comparators on the date

const queryMatch = {departureDate: {$gte: new Date(query.departureDateMin),$lte: new Date(query.departureDateMax)}};
const flightsByCriteria = await this.flightModel.find(queryMatch).exec();

The above request returns an empty table.
And yet I get data with mongodbCompass using ISODate(dateString) instead of new Date(dateString)

I don’t know where the problem lies in my request ?
Thank for your help.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0 
    model.find({
  departureDate: {
    $gte: new Date(query.departureDateMin),
    $lte: new Date(query.departureDateMax),
  },
});

  2. 0

    You should send the dates from the client side in ISO format, so the server would not covert them to the server local time.

    When you are sending dates from the client, you can just send them with calling .toISOString() method:

    {
  departureDateMin: new Date(departureDateMin).toISOString(),
  departureDateMax: new Date(departureDateMax).toISOString(),
}

    Then, you can query database like this:

    const queryMatch = {
  departureDate: {
    $gte: query.departureDateMin,
    $lte: query.departureDateMax,
  }
};
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search