syntax to query a featureLayer using date field with Arcgis JS api?

JohnSnow3 — Sat, 11 Dec 2021 12:08:34 GMT

i have a featureLayer in my JS map, (snapshot_mode), I can make queries on the layer as below (so my issue is specifically how query the layer based on a date field e.g. show all features newer than 01/01/2014) -

 featurelayer.setDefinitionExpression("status = 0"); // for example this is working

I have looked through the documentation, however no success... I am unable to query the layer based on a date field,
I have tried both a static ("date_created > 2014-01-01") as well as passing in a js date variable - "new date(...) and a couple of others,
I also saw there is a setTimeDefinition, which I also attempted to use, but still an unsuccessful outcome,

so, any advice on how to filter by date will be very much appreciated,

thanks!

Re: syntax to query a featureLayer using date field with Arcgis JS api?

SteveCole — Wed, 04 Feb 2015 16:48:43 GMT

Dates values are in Epoch format so you'll need to specify your date value as such. If you have your date of interest as a variable, then the Epoch value of that date would be:

var epochDate = theDate.getTime() / 1000;

Your query then should be

"date_created > " + epochDate

This is untested, though..

topic Re: syntax to query a featureLayer using date field with Arcgis JS api? in ArcGIS JavaScript Maps SDK Questions

syntax to query a featureLayer using date field with Arcgis JS api?

Re: syntax to query a featureLayer using date field with Arcgis JS api?