In ModelBuilder I'm trying to create a table from a subset of dates in a Personal geodatabase table. I'm using "Make Table view" tool.
The date field in the table is [DateCreated]. I have two model parameter variables %Start Date% and %End Date%, both with data type set as date. I would like to return values from the table between these two dates.
I'm struggling to find resources to describe the required syntax. I'm also not very familiar with SQL.
So far I've tried the below with no success
[DateCreated] > #%Start Date%# AND [DateCreated] < #%End Date%# [DateCreated] > %Start Date% AND [DateCreated] < %End Date% [DateCreated] > '%Start Date%' AND [DateCreated] < '%End Date%'
In all of these example the tool returns all rows