topic Re: select by attributes with wildcard, date field in Mapping Questions https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432184#M4682 <HTML><HEAD></HEAD><BODY><SPAN>As far as I know, there is no way to use LIKE on a date field in ArcGIS (correct me if I'm wrong). You can use BETWEEN though. This example will return all dates in 2005 (actually you probably need to adjust the final time to get records from the last day). This works for me, you may have to adjust the date format.</SPAN><BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro">"DateField" BETWEEN date '2005-01-01 00:00:00' and date '2005-12-31 00:00:00'</PRE></BODY></HTML> Wed, 13 Jul 2011 16:31:07 GMT DarrenWiens2 2011-07-13T16:31:07Z select by attributes with wildcard, date field https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432183#M4681 <HTML><HEAD></HEAD><BODY><SPAN>Hello all,</SPAN><BR /><BR /><SPAN>I have a date field that contains hundreds of unique values.&nbsp; I need to select by year.&nbsp; However my sql query: "Fieldname" = date '2009%' is invalid.</SPAN><BR /><BR /><SPAN>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'</SPAN><BR /><BR /><SPAN>I've tried a bunch of different sql combinations and nothing works.&nbsp; Please help!</SPAN><BR /><BR /><SPAN>thanks much,</SPAN><BR /><SPAN>peace</SPAN></BODY></HTML> Wed, 13 Jul 2011 15:39:40 GMT https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432183#M4681 MikeWissner 2011-07-13T15:39:40Z Re: select by attributes with wildcard, date field https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432184#M4682 <HTML><HEAD></HEAD><BODY><SPAN>As far as I know, there is no way to use LIKE on a date field in ArcGIS (correct me if I'm wrong). You can use BETWEEN though. This example will return all dates in 2005 (actually you probably need to adjust the final time to get records from the last day). This works for me, you may have to adjust the date format.</SPAN><BR /><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro">"DateField" BETWEEN date '2005-01-01 00:00:00' and date '2005-12-31 00:00:00'</PRE></BODY></HTML> Wed, 13 Jul 2011 16:31:07 GMT https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432184#M4682 DarrenWiens2 2011-07-13T16:31:07Z Re: select by attributes with wildcard, date field https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432185#M4683 <HTML><HEAD></HEAD><BODY><SPAN>Thanks dkwiens, that was a great idea.</SPAN><BR /><BR /><SPAN>However, I still couldn't get it to work.&nbsp; Any other suggestions?</SPAN></BODY></HTML> Wed, 13 Jul 2011 18:23:17 GMT https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432185#M4683 MikeWissner 2011-07-13T18:23:17Z Re: select by attributes with wildcard, date field https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432186#M4684 <HTML><HEAD></HEAD><BODY><SPAN>It works for me, so my suggestion is to post your SQL statement and a subset of your data.</SPAN></BODY></HTML> Thu, 14 Jul 2011 16:28:34 GMT https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432186#M4684 DarrenWiens2 2011-07-14T16:28:34Z Re: select by attributes with wildcard, date field https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432187#M4685 <HTML><HEAD></HEAD><BODY><P>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&nbsp; and 10 days ago ".. any suggestions ?</P></BODY></HTML> Thu, 24 Mar 2016 10:15:22 GMT https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432187#M4685 IbrahimMohammed_Ahmed 2016-03-24T10:15:22Z Re: select by attributes with wildcard, date field https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432188#M4686 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Thu, 24 Mar 2016 11:40:25 GMT https://community.esri.com/t5/mapping-questions/select-by-attributes-with-wildcard-date-field/m-p/432188#M4686 DanPatterson_Retired 2016-03-24T11:40:25Z