Using an Esri FGDB Reader (an Esri FGDB FeatureReader) in a Workbench, I would like to apply a where clause using the last_updated field. I believe that because this is a date/time field that it is causing me troubles as I am able to run tests on other fields.
What is the correct syntax to enter a where clause on a date/time field from a FGDB?
It’s a SQL query, but it has its own syntax, seems esri doesn’t implicitly convert strings to dates like other products do... I checked how ArcPro creates a definition query on a date. It should look like:
last_updated > timestamp '2023-03-15 12:00:00'
Just found this post - I have a similar scenario (and the solution works for me) but through the FeatureReader I want to find records based on a date compared to another date coming from an attribute. So I want to find records from FC A where FC A publish_date is greater than FC B last_run_time. I’ve tried a few different syntax ways and I feel it should be simple, but I keep getting the error “The error message from ArcObjects is: {An invalid SQL statement was used.}”. I feel like it’s a last_run_time formatting thing and taking @Value(LAST_RUN_TIME) isn’t correct. This is what’s not working..
“publish_date > timestamp(@Value(LAST_RUN_TIME))
Thoughts?
Maybe not the best to comment on my own question, but I figured this out. It was indeed the syntax being fed into the FeatureReader, so I used a StringConcatenator ahead of it to build the correct syntax and create a new attribute to compare to “publish_date”.
Then used the new attribute in the FeatureReader to compare to “publish_date” (I want every record with “publish_date” more recent than “last_update_time” (now “formatted_”)).
