Query with string date format in mongodb

Question

I have a data like below in my mongoDB collection. I want to count the total number or search_term on today basis.

_id:ObjectId("5b7e1d38981cdc1a7c8bb5fc")
search_term:"Baiyoke Boutique"
date:"August 23rd 2018, 9:34:32 am"

_id:ObjectId("5b7e1fa8fa27fd2754080ad9")
search_term:"Baiyoke Boutique"
date:"August 23rd 2018, 9:44:56 am"

_id:ObjectId("5b7e28314d2d0f388c1596cd")
search_term:"Baiyoke Florting Market"
date:"August 23rd 2018, 10:21:21 am"

I have tried following query. I have used moment. I am not what mistake I did.

var start = moment().startOf('day');
var end = moment().endOf('day');

history.find({
    date: {
        $gte: start,
        $lt: end
    }
    }).count().toArray(
    function (e, res) {
        if (e) callback(e)
        else callback(null, res)
});

Answer 1

You can try below queries in mongodb 3.6 and above

db.collection.find({
  "$expr": {
    "$gte": [{ "$dateFromString": { "dateString": "$date" }}, start.toDate() ],
    "$lt": [{ "$dateFromString": { "dateString": "$date" }}, end.toDate() ]
  }
}).count()

or with aggregation

db.collection.aggregate([
  { "$addFields": {
    "date": {
      "$dateFromString": {
        "dateString": "$date"
      }
    }
  }},
  { "$match": { "date": { "$gte": start.toDate(), "$lt": end.toDate() }}},
  { "$count": "count" }
])

Answer 2

You can try this

db.col.aggregate([{$addFields: {
      convertedDate: { $toDate: "$date" }
   }},
   {"$match" : 
       {"convertedDate" : 
           {"$gte" : ISODate("2018-08-23T09:34:32.000Z"),
            "$lte" : ISODate("2018-08-23T09:34:32.000Z")}
        }
    },
    {"$group" : {"_id" : null,"count" : {"$sum" : 1}}},
    {"$project" : {"_id" : 0}}
   ])

This is for Node js

var start = moment().startOf('day');
var end = moment().endOf('day');

history.aggregate([{
    $addFields: {
        convertedDate: { $toDate: "$date" }
    }
},
{
    "$match":
    {
        "convertedDate":
        {
            "$gte": start,
            "$lte": end
        }
    }
},
{ "$group": { "_id": null, "count": { "$sum": 1 } } },
{ "$project": { "_id": 0 } }
], function (err, count) {
    console.log(count)
})