select by attributes with wildcard, date field

Discussion created by mikeldub on Jul 13, 2011
Latest reply on Mar 24, 2016 by Dan_Patterson
Hello all,

I have a date field that contains hundreds of unique values.  I need to select by year.  However my sql query: "Fieldname" = date '2009%' is invalid.

Also, for whatever reason my attributes are displayed in mm/dd/yyyy format, while in the select by attribute unique field box they are displayed as date 'yyyy-mm-dd'

I've tried a bunch of different sql combinations and nothing works.  Please help!

thanks much,