AnsweredAssumed Answered

Select Analysis Whereclause is like date string variable

Question asked by louchios on Feb 5, 2018
Latest reply on Feb 6, 2018 by tkowal

dayString is a string that will change frequently.

 

I would like to use python to select records where my field EXP_CST (date field) in my feature class is on the same day as the date string. However, the date field will also have time elements, so I believe I will need to use the LIKE operator? I am using ArcGIS 10.5.1. Thank you.

 

dayString = '2018-01-31'

arcpy.Select_analysis(Select2, Select3, "EXP_CST LIKE '" + dayString + "'")

 

Outcomes