Is it possible to query for a date range in ArcGIS Pro for a hosted data layer. It gives me a "ERROR 000358: Invalid expression" when I try to select a date using the select by attributes tool. What is the correct format to use when querying for dates on hosted data? I would like to make this query the first step in a task. Thanks for any help.
I too am completed confused by this. All I'm trying to do is use Pro to "Select by Attributes" as shown in the attached screenshot. However, I'm continually told "There was an error with the expression" despite using the query builder. Things to note:
I had to CAST the date string to get it to work like this:
DateSmoke BETWEEN CAST('2018-08-01' AS Date) AND CAST('2018-08-31' AS Date)
DateSmoke > CAST('2018-08-01' AS Date)