Here is the MongoDB Document.

[
  {
    name: "a",
    "start_date": ISODate("2021-09-21T12:13:34.151 05:30"),
    "end_date": ISODate("2021-09-24T12:13:34.000 05:30"),
    
  },
  {
    name: "b",
    "start_date": ISODate("2021-09-21T12:13:34.151 05:30"),
    "end_date": ISODate("2021-09-22T12:13:34.000 05:30"),
    
  },
  {
    name: "c",
    "start_date": ISODate("2021-09-21T12:13:34.151 05:30"),
    "end_date": ISODate("2021-09-21T12:13:34.000 05:30"),
    
  }
]

I want to fetch all data based on the start date and end date.

I have tried with the following.

db.collection.find({
  start_date: {
    $gte: new Date()
  },
  end_date: {
    $lte: new Date()
  }
})

Expected output

If the current date is 2021-09-22, then the output will be

[
  {
    name: "a",
    "start_date": ISODate("2021-09-21T12:13:34.151 05:30"),
    "end_date": ISODate("2021-09-24T12:13:34.000 05:30"),
    
  },
  {
    name: "b",
    "start_date": ISODate("2021-09-21T12:13:34.151 05:30"),
    "end_date": ISODate("2021-09-22T12:13:34.000 05:30"),
    
  },
  
]

If the current date is 2021-09-23, then the output will be

[
  {
    name: "a",
    "start_date": ISODate("2021-09-21T12:13:34.151 05:30"),
    "end_date": ISODate("2021-09-24T12:13:34.000 05:30"),
    
  },
 
]

CodePudding user response：

Kindly change the logic as mentioned below for the required output

db.collection.find({
  start_date: {
    $lte: new Date()
  },
  end_date: {
    $gte: new Date()
  }
})

CodePudding user response：

Use $and for multiple expression.

Note: start_date less than ($lte) current date and end_date greater than ($gte) current date so that current date is within the date range.

db.collection.find({
  $and: [
    {
      start_date: {
        $lte: new Date()
      }
    },
    {
      end_date: {
        $gte: new Date()
      }
    }
  ]
})

Sample Mongo Playground 1

OR

db.collection.find({
  "$expr": {
    "$and": [
      {
        $lte: [
          "$start_date",
          new Date()
        ]
      },
      {
        $gte: [
          "$end_date",
          new Date()
        ]
      }
    ]
  }
})

Sample Mongo Playground 2

CodePudding user response：

    // With NodeJs
    Collection.find({
    $and: [
      {
        start_date: {
          $gte: new Date().toISOString(),
        },
      },
      {
        end_date: {
          $lte: new Date().toISOString(),
        },
      },
    ],
  });