select by attributes with wildcard, date field

Question

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,
peace

DanPatterson_Retired · Answer

posting a new question in a 5 year old thread probably isn't going to pique much interest unless you provide the syntax etc as was suggested in one of the responses

IbrahimMohammed_Ahmed · Answer

thank you, works great. but what i need to do is to get the features that is not being visited between the current_date and a certain period of it, like for example : " where "features" between current_date  and 10 days ago ".. any suggestions ?

DarrenWiens2 · Answer

It works for me, so my suggestion is to post your SQL statement and a subset of your data.