I'm trying to filter within my model so that I only append data that has been created after the last time the model was ran. Within my original data, I have an auto-populating field of "CreationDate" and I have created a Date type parameter that is titled "date_last_ran".
When I enter the following expressions into the Select By Attribute expression, all receive the error "The SQL expression has invalid syntax," and I cannot figure out why.
CreationDate > %date_last_ran%
CreationDate > '%date_last_ran%'
CreationDate > date '%date_last_ran%'
Any help is appreciated!
