Database

[{"creation_date":{"$date":{"$numberLong":"1641981205813"}},"user_id":{"$oid":"61dedd8b7a520461dd78016b"},"products":[{"_id":{"$oid":"61dede397a520461dd7818bd"},"product_id":{"$oid":"615071ae8b66e1e9a3d6ea50"},"payment":true,"support_all_payment":false,"term_ids":null}],"carts_info":[{"_id":{"$oid":"61dede397a520461dd7818be"},"support_type":null,"support_price":0,"product_price":11000,"product_type":"all","final_price":11000,"product_id":{"$oid":"615071ae8b66e1e9a3d6ea50"}}],"_des":"initial_payment","_type":"online","_token":"9e0cb4d111f642f1a6f482bb04f1f57b","_price":11000,"_status":"unpaid","_terminal_id":"12605682","__v":0,"additional_information":{"saman_bank":{"MID":"0","ResNum":"61dede387a520461dd7818bb","State":"CanceledByUser","TraceNo":"","Wage":"","Rrn":"","SecurePan":"","HashedCardNumber":"","Status":"1"}}}]

Query

db.collection.aggregate([{"$match":{$expr:{$eq:[{$dateTrunc:{date:"$creation_date",unit:"day"}},ISODate("2022-01-12")]}}},{$group:{_id:{$dateTrunc:{date:"$creation_date",unit:"day"}},num:{$sum:1}}}])

Result