Database
[{"date_time":"2022-11-05 09:09:55","dat1":"TRUI","cod":"XC"},{"date_time":"2022-11-21 09:09:55","dat1":"TRQW","cod":"KL"},{"date_time":"2022-12-06 09:09:55","dat1":"CBTR","cod":"NM"},{"date_time":"2022-12-18 09:09:55","dat1":"METR","cod":"XC"}]
Query
db.collection.find({$expr:{$and:[{$eq:["$cod","XC"]},{$and:[{$gte:[{$dateFromString:{dateString:"$date_time",format:"%Y-%m-%d %H:%M:%S"}},ISODate("2022-11-01T00:00:00Z")]},{$lt:[{$dateFromString:{dateString:"$date_time",format:"%Y-%m-%d %H:%M:%S"}},ISODate("2023-01-01T00:00:00Z")]}]}]}})