When executing a query that contains a condition “between” two dates, it does not work. Is there a solution?
function () {
return “SELECT sum(totall) FROM data WHERE “date” BETWEEN '”+document.childByName(“date1”).content.text+"’ AND ‘"+document.childByName(“date2”).content.text+"’"
}