title: How to generate report from sqlite database in cordova phonegap?
body: <p>How can I generate daily, Weekly, Monthly reports from sqlite database in cordova phonegap? I can not getting data between two dates. 
  I am applying query 
  "SELECT * FROM sales where saledate &lt;=1-1-2015 AND saledate >=1-1-2016"
  where saledate column type is DATE. </p>