My map service layer has several esriFieldTypeDate fields.
When I query in ArcMap, the format returned in Select by attriburtes is this: TO_DATE('2024-12-31 00:00:00','YYYY-MM-DD HH24:MI:SS')
as the data resides in Oracle SDE.
The actual records look like this: 01/12/1989
When I go to query these fields in the SFV 1.3 query builder, the returned format looks like this: 12/31/2020 12:00:00 AM
and I get an error message "query failed!'
Any ideas what need to be fixed/changed? I have attached a few graphics to illustrate my problem.
The AGREEMENT_END_DATE = TO_DATE('2019-12-31 00:00:00','YYYY-MM-DD HH24:MI:SS') query works fine in ArcMap and the REST map service query layer function. Not sure why I get AGREEMENT_END_DATE = '12/31/2020 12:00:00 AM' when I use this field in the query builder (SFV 1.3) widget.
Thanks for your help,
Susan