Query between two dates

[steevej (Steeve Juneau)]

It would be nice if you could share how you solved it.

That would benefit all including the new user that has something similar in

How to perform an aggregate, returning only documents where an array of subdocuments have a date that falls between 2 dates

I have a collection of bookings, each booking has an array of days the booking covers, each day has a start and end date. I want to return only the bookings that have atleast 1 day within a set of dates. The below feels like it should work but it returns nothing all the time. // Booking { title: "Booking 1", days: [ { start: "2022-12-01T08:30:00.000+00:00", end: "2022-12-03T05:30:00.000+00:00" } ] } const start = "2022-12-01"; const end = "2022-12-07"; BookingsBooking.aggregate([ {…