And operator not working on definition query

327
1
11-04-2022 11:09 AM
TWPFSecretariat
New Contributor II

Hello, 

I am using ArcGIS Pro 2.9.5 and I am trying to select images between dates for Sentinel 2 views. I am using definition query and have it set up like this: 

 acquisitiondate >= timestamp '2020-11-15 14:35:19'

And acquisitiondate <= timestamp '2021-05-01 14:35:51'

The sql statement is valid but returns no results. If I try the same sql statement on arcgis online a get results of imagery within that period. Any ideas? 

0 Kudos
1 Reply
BrittanyBurson
Occasional Contributor III

Also unable to get two text query strings to work with an AND operator 😑 2.9.5