title: How to fetch records after a particular date
body: <p>I am trying to fetch the records that has the "<strong>effectiveDateOfAction</strong>" field greater than Oct'2017. Please find the below 3 records.</p>
  
  <pre><code>{
   "_id": "TRAN001",
   "_rev": "13-59a53069c1ebd6ecfc23ca1dea0ba28f",
   "effectiveDateOfAction": "10-30-2018",
   "employeeName": "Kumar,Vinoth",
   "transferReportID": "TRAN001",
   "~version": "76:0"
  }
  
  {
   "_id": "TRAN001",
   "_rev": "12-c320c61168f5d6d020f971124cb395f2",
   "effectiveDateOfAction": "05-10-2018",
   "employeeName": "Vinoth",
   "transferReportID": "TRAN002",
   "~version": "77:0"
  }
  
  {
   "_id": "TRAN003",
   "_rev": "16-567a15e9ea7e2349d4c24816e7eafda3",
   "effectiveDateOfAction": "10-20-2017",
   "employeeName": "Kumar",
   "transferReportID": "TRAN003",
   "~version": "78:0"
  }
  </code></pre>
  
  <p>Please find my query below which i tried.I am checking using Project Fauxton.</p>
  
  <pre><code>{"selector": {"$and": [{"transferReportID": {"$ne": null}},{"effectiveDateOfAction": {"$gt": "10-31-2017"}}]}}
  </code></pre>
  
  <p>Please help me getting the correct query.</p>