Database
[{_id:0,date:ISODate("2024-07-18T05:43:21.000Z"),group:"1",state:"DONE"},{_id:1,date:ISODate("2024-07-18T06:43:21.000Z"),group:"2",state:"DONE"},{_id:2,date:ISODate("2024-07-18T07:43:21.000Z"),group:"1",state:"FAILED"},{_id:3,date:ISODate("2024-07-18T08:43:21.000Z"),group:"1",state:"DONE"},{_id:4,date:ISODate("2024-07-18T09:43:21.000Z"),group:"2",state:"FAILED"}]
Query
db.collection.find({date:{$lte:ISODate("2024-07-18T09:43:21.000Z"),$not:{"$gt":ISODate("2024-07-18T09:43:21.000Z")}}})