query Date Range syntax

jaykapalczynski

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) + "' ";

RobertScheitlin__GISP

@RobertKirkwood GETDATE() is a SQL server function if you want the date from JS code then it would look like this:

 

query.where = "'" + new Date().toJSON().slice(0,10).replace(/-/g,'/') + "' >= EXPIRATION_DATE";

 

The current date will look like "2022/06/15" based on the JS code above