find_query_by_dates.js

In SQL:
SELECT * FROM users WHERE created_at BETWEEN '2011-05-04' AND '2011-10-10';

In MongoDB:
> start = new Date(2011, 5, 4);
ISODate("2011-06-03T16:00:00Z")
> end = new Date(2011, 10, 10);
ISODate("2011-11-09T16:00:00Z")
> db.users.find({created_at: {$gte: start, $lt: end}});
{ "_id" : ObjectId("4e8c2a00de570598c220878b"), "username" : "Zoloo", "created_at" : ISODate("2011-10-04T16:00:00Z"), "password" : "secret", "last_visited_at" : ISODate("2011-10-04T16:00:00Z") }