Okay, I'm having difficulty working with a Date field. I can get the QUERY to accept an expression like:
NAME = '[Value]' AND RECORD_DATE = date '2010-01-01'
But I can't get it to understand:
NAME = '[Value]' AND RECORD_DATE >= date '2010-01-01' AND RECORD_DATE <= date '2010-02-01'
or
NAME = '[Value]' AND RECORD_DATE = TimeExtent(startTime:date '2010-01-01', endTime:date '2010-02-01')
The first one works in ArcMap, but not in my query widget. The scond one gives me the error:
[RPC Fault faultString="Unable to complete operation." faultCode = "400" faultDetail="Unable to complete query operation."]
Any suggestions?
