Database
[{"_id":"ch_d3b8b9ab","reference":"ch_d3b8b9a","date":"2/2/2022 5:36 PM","payment":"Visa","check":"$19.00","tip":"NO TIP OR CASH","customer_charge":"NO SERVICE CHARGE","total":"$19.00","plan":"Test Plan"},{"_id":"ch_d3b8b9ac","reference":"ch_d3b8b9a","date":"1/1/2020 5:00 PM","payment":"Visa","check":"$19.00","tip":"NO TIP OR CASH","customer_charge":"NO SERVICE CHARGE","total":"$19.00","plan":"Test Plan"}]
Query
db.collection.aggregate([{$match:{"$expr":{"$gt":[{"$dateFromString":{"dateString":{"$substr":["$date",0,8]},"format":"%m/%d/%Y"}},{"$dateFromString":{"dateString":"1/1/2021","format":"%m/%d/%Y"}}]}}}])