AnsweredAssumed Answered

Select Layer by Attributes for a Date Field is not NULL fails (invalid expression) even validating succeeds - Enterprise DB - Oracle 11g

Question asked by eggie on Mar 27, 2017
Latest reply on Mar 29, 2017 by eggie

ArcGIS Pro 1.4

DB:  Oracle 11g

 

Run Select Layer by Attribute on a Date Field ( is NOT NULL or is NULL) even successfully validating.  Error ,

 

 ERROR 000358: Invalid expression
Failed to execute (SelectLayerByAttribute).

selectlayerbyattribute

 

Sorry, cant delete this post.  pls ignore this as i tried the same in ArcMap and it throws some Oracle error.  The problem is this data is not ours.   we can not work on it.  a copy of this in our own database is fine both for ArcPro and Arcmap.

Outcomes