I'm migrating my services from ArcGIS Server 10.05 to 10.21, and I'm having trouble with querys using date (esriFieldTypeDate) fields.
On the Where parameter I put the following text:
DTINCORPORACAO < '10/06/2014' AND CODMUNICIPIO =2740
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:
10.05 service OBJECTID: 646 CODSIMOV: 0000006391 DTINCORPORACAO: 2000/07/05 00:00:00 UTC
10.21 service OBJECTID: 329 CODSIMOV: 0000006391 DTINCORPORACAO: 962755200000