[{"_id":"1235847","LineItems":[{"StartDate":ISODate("2017-07-31T00:00:00.000+00:00"),"EndDate":ISODate("2017-09-19T00:00:00.000+00:00"),"Amount":{"$numberDecimal":"0.00"}},{"StartDate":ISODate("2022-03-20T00:00:00.000+00:00"),"EndDate":ISODate("2022-10-21T00:00:00.000+00:00"),"Amount":{"$numberDecimal":"6.38"}},{"StartDate":ISODate("2022-09-20T00:00:00.000+00:00"),"EndDate":ISODate("9999-12-31T00:00:00.000+00:00"),"Amount":{"$numberDecimal":"6.17"}}]},{"_id":"1235848","LineItems":[{"StartDate":ISODate("2017-07-31T00:00:00.000+00:00"),"EndDate":ISODate("2017-09-19T00:00:00.000+00:00"),"Amount":{"$numberDecimal":"0.00"}},{"StartDate":ISODate("2021-03-20T00:00:00.000+00:00"),"EndDate":ISODate("2021-10-21T00:00:00.000+00:00"),"Amount":{"$numberDecimal":"6.38"}},{"StartDate":ISODate("2022-09-20T00:00:00.000+00:00"),"EndDate":ISODate("9999-12-31T00:00:00.000+00:00"),"Amount":{"$numberDecimal":"6.17"}}]},{"_id":"1235849","LineItems":[{"StartDate":ISODate("2017-07-31T00:00:00.000+00:00"),"EndDate":ISODate("2017-09-19T00:00:00.000+00:00"),"Amount":{"$numberDecimal":"0.00"}},{"StartDate":ISODate("2017-08-20T00:00:00.000+00:00"),"EndDate":ISODate("2017-10-21T00:00:00.000+00:00"),"Amount":{"$numberDecimal":"6.38"}},{"StartDate":ISODate("2022-09-20T00:00:00.000+00:00"),"EndDate":ISODate("9999-12-31T00:00:00.000+00:00"),"Amount":{"$numberDecimal":"6.17"}}]},{"_id":"1235850"},{"_id":"1235851","LineItems":[{"StartDate":ISODate("2017-07-31T00:00:00.000+00:00"),"EndDate":ISODate("2017-09-19T00:00:00.000+00:00"),"Amount":{"$numberDecimal":"0.00"}}]}]

db.collection.find({"$expr":{"$getField":{"field":"overlapped","input":{"$reduce":{"input":{"$slice":["$LineItems",1,{"$size":"$LineItems"}]},"initialValue":{"overlapped":false,"prevEnd":{"$first":"$LineItems.EndDate"}},"in":{"overlapped":{"$or":["$$value.overlapped",{"$lt":["$$this.StartDate","$$value.prevEnd"]}]},"prevEnd":"$$this.EndDate"}}}}}})