[{_id:ObjectId("63920f965d15e98e3d7c450c"),project_end_time:ISODate("2022-12-26T10:09:49.753Z"),},{_id:ObjectId("63920f965d15e98e3d7c451c"),regular_end_date:ISODate("2022-12-26T10:09:49.753Z"),},{_id:ObjectId("63920f965d15e98e3d7c452c"),events:[{id:1,date:ISODate("2022-12-29T10:09:49.753Z")},{id:3,date:ISODate("2022-12-26T10:09:49.753Z")}]},{_id:ObjectId("63920f965d15e98e3d7c453c"),regular_end_date:ISODate("2022-12-29T10:09:49.753Z")},{_id:ObjectId("63920f965d15e98e3d7c454c"),events:[{id:1,date:ISODate("2022-12-29T10:09:49.753Z")},{id:3,date:ISODate("2022-12-28T10:09:49.753Z")}]},]

db.collection.find({$or:[{$and:[{project_end_time:{$exists:true}},{project_end_time:{$lt:ISODate("2022-12-27T10:09:49.753Z")}}]},{$and:[{regular_end_date:{$exists:true}},{regular_end_date:{$lt:ISODate("2022-12-27T10:09:49.753Z")}}]},{$and:[{"events.0":{$exists:true}},{"$expr":{"$lt":[{"$last":"$events.date"},ISODate("2022-12-27T10:09:49.753Z")]}}]}]})