Confused by date field query

Discussion created by springsgirl on Dec 12, 2011
Latest reply on Dec 14, 2011 by springsgirl
I've only been messing around with Python for a few months and am having trouble understanding how to script for a date field.  Does this require the dateTime functions or just a correctly built SQL query??

Specifically I have a shapefile with a date field that I would like to be able to pull all records (or at least get a count of all records) that were worked on within a fiscal year.  So to be able to look at Oct 1, 2011 to Sept 30, 2012.

I've been looking through the ArcGIS 10.0 help topics and can't seem to find specifics other than the the format of the "datefield" = 'yyyy-mm-dd'.

Thanks for any pushes in the right direction or help topics!