Can't use $and with Date.

[Charlie]

I have a simple $and query like this:

{

  "start": {

    $and: [

      { $gte: date1 },

      { $lte: date2 }

    ]

  }

}

I'm getting the error "Can't use $and with Date.".  This seems like an odd limitation.  Are there any fixes or efficient workarounds to this?

I suppose I could store the dates as numbers in the database but I'd rather keep them as Date objects if possible.

Thanks

[Nat]

Shouldn't this work without $and?

{
  "start": {
    $gte: date1,
     $lte: date2
  }
}

---

From: Charlie <cha...@powmedia.co.uk>

Sender: mongod...@googlegroups.com

Date: Wed, 1 Aug 2012 17:33:52 -0700 (PDT)

To: <mongod...@googlegroups.com>

ReplyTo: mongod...@googlegroups.com

Subject: [mongodb-user] Can't use $and with Date.

--
You received this message because you are subscribed to the Google
Groups "mongodb-user" group.
To post to this group, send email to mongod...@googlegroups.com
To unsubscribe from this group, send email to
mongodb-user...@googlegroups.com
See also the IRC channel -- freenode.net#mongodb

[Charles Davison]

D'oh!  Don't know why I thought I had to use an $and for this.. time to get some sleep!

Thanks for the quick help!