Select to view content in your preferred language

And operator not working on definition query

433
1
11-04-2022 11:09 AM
TWPFSecretariat
Occasional Contributor

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
Frequent Contributor

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