There appears to be a glitch in the ArcGIS Pro definition query for dates and times. The date-time format changes between the clause and sql view and when the query is applied - completely muddling up the query and making it impossible to select data for a specific time period.
- Open a new map;
- Add Sentinel-2 Views from Living Atlas (Category: Imagery);
- Create a new definition query, using 'acquisitiondate'
- Update the definition query and change to the SQL view
- Swap back to the Clause view - the date-time format is muddled up.
The same happens if you create a definition query using the SQL view to start off instead of using the clause view. Does anyone know a workaround?
Thank you in advance.