topic Re: Attribute Selections in Pro using 'timestamp' Issue in ArcGIS Pro Questions

Attribute Selections in Pro using 'timestamp' Issue

LarryGaudieri1 — Thu, 01 Jun 2017 11:50:40 GMT

After a skim of online documentation for date & time queries (Time Expressions in Pro) I am confused. I cannot select a date range using Select Layer by Attribute and the clause function. It offers a date-picker or I can scroll to a specific timestamp but when the expression is complete (and looks valid anyhow) it continually reports an error with the expression. Am I missing something?

Re: Attribute Selections in Pro using 'timestamp' Issue

AndrewHargreaves2 — Tue, 14 Aug 2018 20:16:05 GMT

I have this issue too - and am frustrated.

arcgis pro 2.2‌

David Watkins‌

Re: Attribute Selections in Pro using 'timestamp' Issue

MichaelVolz — Tue, 11 Sep 2018 19:28:25 GMT

Can you supply some screenshots of what your query looks like?

What version of Pro are you using?

Re: Attribute Selections in Pro using 'timestamp' Issue

DeenaBowman — Fri, 18 Jan 2019 16:54:23 GMT

Hello, I'm having the same issue. I'm using Pro 2.2.4, and the data are an ArcGIS Online hosted feature layer

Re: Attribute Selections in Pro using 'timestamp' Issue

MichaelVolz — Fri, 18 Jan 2019 17:15:30 GMT

I just tested Pro 2.2.4 with a similar date query to your screenshot and it successfully executed the query. I did this test against both a file gdb and Oracle 12c SDE database.

What is the source of your data (e.g.file gdb, enterprise SDE database, shapefile, other)?

Did you create the data yourself or import it from another source?

Re: Attribute Selections in Pro using 'timestamp' Issue

DeenaBowman — Fri, 18 Jan 2019 17:45:55 GMT

The data are published as an ArcGIS Online hosted layer. I've tested with other feature layers published to AGO (by me and others) with the same issue. I'm not having any issues with file-gdbms, enterprise SDE or shapefiles.

Re: Attribute Selections in Pro using 'timestamp' Issue

MichaelVolz — Fri, 18 Jan 2019 17:54:51 GMT

Thanks for the additional information. I think the key is the data is an AGOL hosted layer as this tool also fails for me in this scenario at Pro 2.2.4.

Maybe the title of this post needs to be modified to reflect the problem is narrower and based on an AGOL hosted feature layer source.

Re: Attribute Selections in Pro using 'timestamp' Issue

DeenaBowman — Fri, 18 Jan 2019 18:00:13 GMT

Hi Michael, I just stumbled onto this post. I will create a new posting to reflect the AGOL component. Thanks for confirming!

Re: Attribute Selections in Pro using 'timestamp' Issue

MichaelVolz — Fri, 18 Jan 2019 18:13:10 GMT

If this is an important workflow feature for you in Pro, I would start a technical support incident with ESRI.