AnsweredAssumed Answered

query Date Range syntax

Question asked by jay.kapalczynski on Apr 3, 2017
Latest reply on Apr 3, 2017 by jay.kapalczynski

Wondering if anyone can help with the syntax to query a date range?

 

query.where = "County_Nam = '" + (dom.byId("CountyName").value) + "' AND Squad = '" + (dom.byId("Squad").value) + "' ";

 

query.where = "County_Nam = '" + (dom.byId("CountyName").value) + "' AND Squad = '" + (dom.byId("Squad").value) + "' AND DateIncident = '" + (dom.byId("StartDate").value) + "' BETWEEN DateIncident = '" + (dom.byId("EndDate").value) + "' ";

 

Outcomes