topic Re: Selecting specific Date in ArcGIS Pro Questions

Selecting specific Date

SLouq — Thu, 10 Jul 2025 13:30:10 GMT

I have a list of Hydrant attributes which is updated using Survey123 and need to copy the newly collected data to a live feature class hosted on a database server. To do this I want to create a model in modelbuilder to only select the latest attributes and not the others. I can do this by using the Select layer Attributes geoprocessing tool but am having trouble finding which expression to use for Date_Time.

Seems the only expression I can get to work is Date_Time is not null

Can someone help with the correct Date_Time expression?

Thanks

Re: Selecting specific Date

DanPatterson — Thu, 10 Jul 2025 14:12:00 GMT

depending on the database you are using, did you see the sql date-time query examples in the help?

SQL reference for query expressions used in ArcGIS—ArcGIS Pro | Documentation

Re: Selecting specific Date

SLouq — Thu, 10 Jul 2025 14:37:38 GMT

Got it. The field type is set to Date only so when I pick from the calendar it inputs a date and time which throws a syntax error. If I delete the time portion of the input, then the compiler will accept it.