topic Troubles on Query With Date in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/troubles-on-query-with-date/m-p/327221#M1596 <HTML><HEAD></HEAD><BODY><SPAN>I'm migrating my services from ArcGIS Server 10.05 to 10.21, and I'm having trouble with querys using date (esriFieldTypeDate) fields.</SPAN><BR /><BR /><SPAN>On the Where parameter I put the following text:</SPAN><BR /><BR /><SPAN>DTINCORPORACAO &lt; '10/06/2014' AND CODMUNICIPIO =2740</SPAN><BR /><BR /><SPAN>Both services are identical, have the same base, field and field types, but on the 10.21 service it doesn't returns results, and when I query it to bring every register (typing "1=1" on the Where field) with the DTINCORPORACAO on the outfields, it brings the results as the following:</SPAN><BR /><BR /><SPAN>10.05 service</SPAN><BR /><SPAN>OBJECTID: 646</SPAN><BR /><SPAN>CODSIMOV: 0000006391</SPAN><BR /><SPAN>DTINCORPORACAO: 2000/07/05 00:00:00 UTC</SPAN><BR /><BR /><SPAN>10.21 service</SPAN><BR /><SPAN>OBJECTID: 329</SPAN><BR /><SPAN>CODSIMOV: 0000006391</SPAN><BR /><SPAN>DTINCORPORACAO: 962755200000</SPAN></BODY></HTML> Wed, 18 Jun 2014 11:58:56 GMT jonataspovoas 2014-06-18T11:58:56Z Troubles on Query With Date https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/troubles-on-query-with-date/m-p/327221#M1596 <HTML><HEAD></HEAD><BODY><SPAN>I'm migrating my services from ArcGIS Server 10.05 to 10.21, and I'm having trouble with querys using date (esriFieldTypeDate) fields.</SPAN><BR /><BR /><SPAN>On the Where parameter I put the following text:</SPAN><BR /><BR /><SPAN>DTINCORPORACAO &lt; '10/06/2014' AND CODMUNICIPIO =2740</SPAN><BR /><BR /><SPAN>Both services are identical, have the same base, field and field types, but on the 10.21 service it doesn't returns results, and when I query it to bring every register (typing "1=1" on the Where field) with the DTINCORPORACAO on the outfields, it brings the results as the following:</SPAN><BR /><BR /><SPAN>10.05 service</SPAN><BR /><SPAN>OBJECTID: 646</SPAN><BR /><SPAN>CODSIMOV: 0000006391</SPAN><BR /><SPAN>DTINCORPORACAO: 2000/07/05 00:00:00 UTC</SPAN><BR /><BR /><SPAN>10.21 service</SPAN><BR /><SPAN>OBJECTID: 329</SPAN><BR /><SPAN>CODSIMOV: 0000006391</SPAN><BR /><SPAN>DTINCORPORACAO: 962755200000</SPAN></BODY></HTML> Wed, 18 Jun 2014 11:58:56 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/troubles-on-query-with-date/m-p/327221#M1596 jonataspovoas 2014-06-18T11:58:56Z