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?
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?
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.
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.