Database
[{"date_time":ISODate("2022-11-05T09:09:55Z"),"dat1":"TRUI","cod":"XC"},{"date_time":ISODate("2022-11-21T09:09:55Z"),"dat1":"TRQW","cod":"KL"},{"date_time":ISODate("2022-12-06T09:09:55Z"),"dat1":"CBTR","cod":"NM"},{"date_time":ISODate("2022-12-18T09:09:55Z"),"dat1":"METR","cod":"XC"}]
Query
db.collection.find({cod:"XC",date_time:{$gte:ISODate("2022-11-01T00:00:00Z"),$lt:ISODate("2023-01-01T00:00:00Z")}})