title: Query using range of date in MongoDB in Java
body: <p>I am new at using MongoDB. I have it filled with receipts, for example: one receipt looks like this :</p>
  
  <pre><code>{ 
    "_id" : { 
            "$oid" : "510fa057c6f818c2bfd0b279"
            } ,
  
    "StoreName" : "Metro" ,
    "StoreNumber" : 521 , 
    "Items" : [ { 
                 "ItemName" : "Battery" , 
                 "ItemManufacturer" : "Duracell" ,
                 "ItemPrice" : 12 ,
                 "ItemQuantity" : 2 , 
                 "ItemTotalPrice" : 24
                } , 
  
                { 
                 "ItemName" : "TV CRT 25 inch" , 
                 "ItemManufacturer" : "Toshiba" , 
                 "ItemPrice" : 1659 , 
                 "ItemQuantity" : 1 , 
                 "ItemTotalPrice" : 1659
                } ,
                { 
                  "ItemName" : "Mobile" , 
                  "ItemManufacturer" : "Nokia" , 
                  "ItemPrice" : 2966 , 
                  "ItemQuantity" : 4 , 
                  "ItemTotalPrice" : 11864
               }
            ] ,
    "Date" : {
              "$date" : "2012-06-16T01:21:11.758Z"
             } , 
    "Total" : 13547
  }
  </code></pre>
  
  <p>I need to make a query where I specify a range of dates to get all the receipts in that range.  I've tried the following query, but it returns nothing.</p>
  
  <pre><code>  BasicDBObject query = 
         new BasicDBObject(
             "Date", 
             new BasicDBObject(
                 "$gt", 
                 "2012-06-20T10:05:21.968Z"
             ).append(
                 "$lte",
                 "2012-09-24T05:29:43.031Z"
             )
         );
  </code></pre>