Database
[{"_id":"6242dc818cd686716633be36","company":"Ledner Inc","dateCreated":ISODate("2022-03-27T21:24:36.000Z"),"createdBy":ObjectId("62399147d817b82f5fe8f927"),},{"_id":"6242dc818cd686716633be37","company":"Ledfdner Inc","dateCreated":ISODate("2022-03-16T21:24:36.000Z"),"createdBy":ObjectId("62399147d817b82f5fe8f927"),},{"_id":"6242dc818cd686716633be38","company":"Lednsdfer Inc","dateCreated":ISODate("2022-03-11T21:24:36.000Z"),"createdBy":ObjectId("62399147d817b82f5fe8f927"),},{"_id":"6242dc818cd686716633be39","company":"Ledfsdgner Inc","dateCreated":ISODate("2022-03-22T21:24:36.000Z"),"createdBy":ObjectId("62399147d817b82f5fe8f927"),},{"_id":"6242dc818cd686716633be30","company":"Ledjhkner Inc","dateCreated":ISODate("2022-03-24T21:24:36.000Z"),"createdBy":ObjectId("62399147d817b82f5fe8f927"),},{"_id":"6242dc818cd686716633be31","company":"Ledhjkhner Inc","dateCreated":ISODate("2022-03-17T21:24:36.000Z"),"createdBy":ObjectId("62399147d817b82f5fe8f927"),},{"_id":"6242dc818cd686716633be32","company":"Lkehjkdner Inc","dateCreated":ISODate("2022-03-26T21:24:36.000Z"),"createdBy":ObjectId("62399147d817b82f5fe8f927"),},{"_id":"6242dc818cd686716633be33","company":"Lekhjkjhdner Inc","dateCreated":ISODate("2022-03-18T21:24:36.000Z"),"createdBy":ObjectId("62399147d817b82f5fe8f927"),},{"_id":"6242dc818cd686716633be34","company":"Lednjkkjhkjhkler Inc","dateCreated":ISODate("2022-03-18T21:24:36.000Z"),"createdBy":ObjectId("62399147d817b82f5fe8f926"),}]
Query
db.collection.aggregate([{$match:{createdBy:ObjectId("62399147d817b82f5fe8f927"),dateCreated:{$gte:ISODate("2022-02-27T21:24:36.000Z"),$lt:ISODate("2022-04-27T21:24:36.000Z")},}},{"$addFields":{"week":{$week:"$dateCreated"}}},{$project:{data:"$$ROOT"}},{$group:{_id:"$data.week",week:{$first:"$data.week"},data:{$push:"$data"}}}])