topic ArcGIS query layer for date in ArcGIS JavaScript Maps SDK Questions https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/arcgis-query-layer-for-date/m-p/601503#M56267 <HTML><HEAD></HEAD><BODY><SPAN>Hi, </SPAN><BR /><BR /><SPAN>I am current trying to do layer definitions on a map and so I am trying to filter some records via a time factor so i was writing in the Where field DATE_CLOSED_ON &gt; (CURRENT_TIME - 24) and DATE_CLOSED_ON is not NULL.</SPAN><BR /><BR /><SPAN>I believe that in order to query a date field there is a must to include the field is not null. As for the time factor I am trying to query records that are closed less than 24 hours ago but the query keep returning me all records with a non null DATE_CLOSED_ON field.</SPAN><BR /><BR /><A href="http://gis.stackexchange.com/questions/44427/arcgis-query-layer-for-date">http://gis.stackexchange.com/questions/44427/arcgis-query-layer-for-date</A></BODY></HTML> Thu, 20 Dec 2012 08:05:15 GMT jonathanlee1 2012-12-20T08:05:15Z ArcGIS query layer for date https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/arcgis-query-layer-for-date/m-p/601503#M56267 <HTML><HEAD></HEAD><BODY><SPAN>Hi, </SPAN><BR /><BR /><SPAN>I am current trying to do layer definitions on a map and so I am trying to filter some records via a time factor so i was writing in the Where field DATE_CLOSED_ON &gt; (CURRENT_TIME - 24) and DATE_CLOSED_ON is not NULL.</SPAN><BR /><BR /><SPAN>I believe that in order to query a date field there is a must to include the field is not null. As for the time factor I am trying to query records that are closed less than 24 hours ago but the query keep returning me all records with a non null DATE_CLOSED_ON field.</SPAN><BR /><BR /><A href="http://gis.stackexchange.com/questions/44427/arcgis-query-layer-for-date">http://gis.stackexchange.com/questions/44427/arcgis-query-layer-for-date</A></BODY></HTML> Thu, 20 Dec 2012 08:05:15 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/arcgis-query-layer-for-date/m-p/601503#M56267 jonathanlee1 2012-12-20T08:05:15Z