https://community.esri.com/t5/modelbuilder-questions/date-parameter-not-working-in-select-by-attribute/m-p/1709433#M4152 <P>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".&nbsp;</P><P>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.</P><P>CreationDate &gt; %date_last_ran%</P><P>CreationDate &gt; '%date_last_ran%'</P><P>CreationDate &gt; date '%date_last_ran%'</P><P>Any help is appreciated!</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 23 Jun 2026 22:22:36 GMT MKRichter 2026-06-23T22:22:36Z https://community.esri.com/t5/modelbuilder-questions/date-parameter-not-working-in-select-by-attribute/m-p/1709433#M4152 <P>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".&nbsp;</P><P>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.</P><P>CreationDate &gt; %date_last_ran%</P><P>CreationDate &gt; '%date_last_ran%'</P><P>CreationDate &gt; date '%date_last_ran%'</P><P>Any help is appreciated!</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 23 Jun 2026 22:22:36 GMT https://community.esri.com/t5/modelbuilder-questions/date-parameter-not-working-in-select-by-attribute/m-p/1709433#M4152 MKRichter 2026-06-23T22:22:36Z