Featurelayer DefinitionExpression based on Date Range

evtguy

I have a layer of construction closures in an app I'm developing and for each closure, there is a field for the starting date of the closure (startDate) and a field for the ending date of the closure (endDate). Ideally, I'd like to add a definitionExpression to the FeatureLayer to automatically handle the visibility of any current closures.

I know I can't just use:

var curDate = new Date();

var fLayer = new FeatureLayer("url", {
    definitionExpression:  "endDate <= Date " + curDate;
    mode: FeatureLayer.MODE_ONDEMAND
});

because that would show current projects but also older, expired projects. So how would I structure the definition expression?

Thanks!

Steve

RobertWinterbottom

This partially depends on how the data is stored in the service. For an esriFieldTypeDate. We have used the following to some success, this was from a filter that said show everything in the last 48 hours.

ACQ_DATE > date '2015-08-28 15:19:35'

However since you want to show things in between two dates, you could use something like this:

startDate > date '2015-08-28 15:19:35' and endDate < date '2015-08-31 15:19:35';

The date strings (eg. '2015-08-28 15:19:35') were formatted using JavaScripts Date class in my case, but they are getting sent in as strings so you can construct them in whatever manner is most appropriate for your application.  Hope this helps.