How to check the particular data in range using mongodb query?

Question

I tried to search MongoDB id in a particular date range using MongoDB query. but it's throwing an error can anyone give any suggestion.

Mongo DB Data

[{
id:1,
full_name:"naveen",
date:"2019-11-02"
},{
id:2,
full_name:"naveen123",
date:"2019-11-04"
}]

mongodb query

db.collection.find({id:1,date:{ '$gte': 2019-11-02,
     '$lt': 2019-11-06 }})

Here is an example of querying for a range: Query for ranges. Also, the date field is a string in the input document, but you are not using it as a string in the query filter. — prasad_
– prasad_, Commented Nov 7, 2019 at 14:30

niranjan_harpale · Accepted Answer · 2019-11-07 14:33:53Z

1

You are missing commas for date values in the query.

Modify your query like below:

db.collection.find({id:1, date:{ "$gte": "2019-11-02", "$lt": "2019-11-06" }});

This is how you may like to do it, but not me.

There are some changes I suggest you should do if you are not already doing it.

1. If you are storing dates as strings in DB, don't do that.

use proper Date format, both while querying and storing.

2. use below format of query:

db.collection.find({id:1, date:{ /* cond1 */ }, 
     date: { /* cond2 */ }
});

answered Nov 7, 2019 at 14:33

niranjan_harpale

2,2942 gold badges20 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1