Database
[{userName:"Bob",userActivity:{"hourly":[ISODate("2022-05-09T02:31:12.062Z"),ISODate("2022-05-13T19:37:42.870Z")]}},{userName:"Bobby",userActivity:{"hourly":[ISODate("2022-05-09T02:31:12.062Z"),ISODate("2022-05-09T19:37:42.870Z")]}}]
Query
db.collection.aggregate([{"$addFields":{"loggedInADayBefore":{"$anyElementTrue":[{"$map":{"input":"$userActivity.hourly","as":"time","in":{"$gte":["$$time",ISODate("2022-05-13T00:00:00.000Z")]}}}]}}},{"$match":{loggedInADayBefore:true}},{"$project":{loggedInADayBefore:0}}])