Finding missing date using aggregation

[steevej (Steeve Juneau)]

You may be able to use $range in an aggregation to generate the missing days.

See the following thread for examples specific to using dates.

How project all day between two date?

Initially you said that you were using the date type: But your sample data shows a string "2022-01-10" - now you can convert that to proper ISODate by using $toDate expression, but I’m hoping maybe it’s just a typo and the dates are already stored as dates and not strings. In either case, there are a lot of different ways this can be done, here is one way you can do what you describe (and I’m assuming you want separate documents at the end rather than an array of dates like the original inpu…