Export Features based on Unique Value in a Field (date value)

[ChristopherBlinn]

Hello All,

I am trying to figure out a way to select records from a shapefile (a specific date in (m)m/(d)d/yyyy format, (m) and (d) only for double digits) and export the selection to create a new shapefile.  The issue is I have over 400 of these dates, and rather than selecting each one individually, right clicking the layer, exporting the data, wash, rinse repeat, I'd like to figure out a way to do this like an iteration in modelbuilder.

I read over this post: http://forums.arcgis.com/threads/27764-Model-Iterator-for-Date-Ranges

It sounds similar to what I am doing except I only have one field for a date, and I just need to select and extract features with similar dates.  Also, I am a newbie with modelbuilder and I don't really mess with python, so the script in the forum above is like reading a different language.

Any help is appreciated and thank you in advance!

Best,
Chris

[ChristopherBlinn]

I should add that I am using ArcGIS 10.0 SP1

[ChristopherBlinn]

Here is the model I have started.  I can't seem to get the SQL correct for it to work.

"DATE_" = Value

I have also tried:

"DATE_" = %Value%

[ChristopherBlinn]

I fixed the issue, my SQL needed to say:

DATE_ = date '%Value%'