Interesting, how do I get that when writing a query?Currently, I'm setting it up like this:
esriDate: function(date) {
var dateArr = date.split('-');
dateArr.push(dateArr.shift());
return dateArr.map(function(el) { return parseInt(el, 10); } ).join('/');
},
buildQuery: function() {
var query = [];
var name = this.username.value;
var startDate = this.startDate.value;
var endDate = this.endDate.value;
if(name) {
query.push("username LIKE '%"+name+"%'");
}
if(startDate) {
query.push("time > '"+this.esriDate(startDate)+"'");
}
if(endDate) {
query.push("time < '"+this.esriDate(endDate)+"'");
}
if(query.length > 1) {
return query.join(' AND ');
} else {
return query.join('');
}
},
submitQuery: function(e) {
e.preventDefault();
var query = new Query();
query.returnGeometry = true;
query.where = this.buildQuery();
this.layer.selectFeatures(query, this.layer.SELECTION_NEW, function(data) {
console.log(data);
// var extent = graphicsUtils.graphicsExtent(data);
// map.setExtent(extent, true);
});
menus.closeFeatureQuery();
this.destroy();
}
The query looks "mostly" SQLish. How do I specify that it's a date?