Database
/*** Paste one or more documents here*/[{"last_date":"22/07/2020 23:48:32","history_dates":["22/07/2020 23:48:32","22/07/2020 00:18:53","23/07/2020 00:49:12","23/07/2020 01:19:30"],"hostname":"MyHostname1","ip":"142.0.111.79","component":"C:\\Windows\\System32\\es-ES\\KernelBase.dll.mui","process":"LogonUI.exe","date":"23/07/2020 10:26:04"},{"last_date":"22/07/2020 23:48:33","history_dates":["22/07/2020 23:48:33","23/07/2020 00:18:53",],"hostname":"MyHostName2","ip":"142.0.111.54","component":"C:\\Windows\\System32\\es-ES\\KernelBase.dll.mui","process":"svchost.exe","date":"23/07/2020 10:26:04"}]
Query
db.collection.aggregate([{$addFields:{history_dates:{$filter:{input:"$history_dates",cond:{$and:[{$gt:["$$this","23/07/2020"]},{$lt:["$$this","24/07/2020"]}]}}}}}])