Selecting specific Date

[SLouq]

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

[DanPatterson · Accepted solution]

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

[SLouq]

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.