Hello.

I have documents with the following format:

time : {
"day": 5,
"month": 10,
"year": 2012,
"hour": 22,

Can I find objects in a date range?

In other words

I want

  2011<=year<=2012

where year is 2011 (but not 2012), I also want
  4<=month

where year is 2012 (but not 2011), I also want
  month<=7

They can at least get it to sort like this using $sort. I want to return
objects where the index key is between a certain range using the
aggregation framework!

Thank you in advance!
/J

If you using the aggregation framework, it may be preferable to work with
an actual BSON Date and then use the date operators<http://docs.mongodb.org/manual/reference/aggregation/#date-operators> to
exact and project parts of the date as needed.

If you're dealing with individual fields for the data components, I can't
think of a simple query to handle that (without some deep $and/$or
nesting). It would be much simpler to work with a Date field, which can
easily be indexed, and then query between two ranges on that one field.
That would remove the need for a multi-key index and certainly prove more
efficient (storage and performance-wise).

Thanks Jeremy for your reply.

The reason that I do not use BSON date is that it is *not local sensitive*.
See my previous topic on the issue:

https://groups.google.com/forum/?fromgroups=#!topic/mongodb-user/okVT...

Since sorting in this order is possible you'd think that you could do some
greater than/less than on compound indexes. If anyone else has some input
please share.

Otherwise I guess the way to go is to add another field that is a timestamp
that compensated for the current timezone as an index.

Den fredagen den 12:e oktober 2012 kl. 23:11:40 UTC+2 skrev Jeremy Mikola: