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

[ReginaldoPaderon]

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.

[DanPatterson_Retired]

marked as Assumed Answered to let it float with your comments.

[ReginaldoPaderon]

Hi Dan,

      Perhaps, Pro can have the same detailed error message ( stating the Oracle number error etc ) as that of ArcMaps...As it is now, Pro's  message was only " ... invalid SQL expression .. ".

Just a suggestion.