Database

[{_id:ObjectId("5e70ed53de0f7507d4da8dc2"),"TICKET_NO":1000,"SUBJECT":"Sub1","DESCRIPTION":"Desc1","createdAt":ISODate("2020-03-17T15:31:31.039Z"),},{_id:ObjectId("5e70ed53de0f7507d4da8dc3"),"TICKET_NO":1001,"SUBJECT":"Sub2","DESCRIPTION":"Desc2","createdAt":ISODate("2020-03-20T15:31:31.039Z"),},{_id:ObjectId("5e70ed53de0f7507d4da8dc4"),"TICKET_NO":1002,"SUBJECT":"Sub3","DESCRIPTION":"Desc3","createdAt":ISODate("2020-03-17T06:31:31.039Z"),},{_id:ObjectId("5e70ed53de0f7507d4da8dc5"),"TICKET_NO":1003,"SUBJECT":"Sub4","DESCRIPTION":"Desc4","createdAt":ISODate("2020-03-18T15:31:31.039Z"),},{_id:ObjectId("5e70ed53de0f7507d4da8dc6"),"TICKET_NO":1004,"SUBJECT":"Sub5","DESCRIPTION":"Desc5","createdAt":ISODate("2020-03-17T18:31:31.039Z"),}]

Query

db.collection.find({createdAt:{$gte:ISODate("2020-03-17T00:00:00.000Z"),$lt:ISODate("2020-03-18T00:00:00.000Z")}})

Result