topic Re: Incorrect syntax near the keyword 'FROM' in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160676#M5406 <HTML><HEAD></HEAD><BODY><P>What about moving the right-parenthesis over to before the less than comparison:</P><P></P><P>(EXTRACT(YEAR FROM CURRENT_DATE) - EXTRACT(YEAR FROM "DateReported")) &lt; 10 AND "Facility" = 'Main' AND ("Cause" = 'Other' OR "DateRepaired" IS NULL)</P></BODY></HTML> Fri, 02 Oct 2015 00:50:16 GMT JoshuaBixby 2015-10-02T00:50:16Z Incorrect syntax near the keyword 'FROM' https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160673#M5403 <HTML><HEAD></HEAD><BODY><P>i'm having an issues here, I'm trying to Select by attributes and using the following</P><P></P><P>(EXTRACT(YEAR FROM CURRENT_DATE) - EXTRACT(YEAR FROM "DateReported") &lt; 10) AND "Facility" = 'Main' AND&nbsp; ("Cause" = 'Other' OR "DateRepaired" IS NULL)</P><P></P><P>and I'm getting the following error</P><P></P><P>Incorrect syntax near the keywrod 'FROM'</P></BODY></HTML> Thu, 01 Oct 2015 21:06:34 GMT https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160673#M5403 ChrisPolley 2015-10-01T21:06:34Z Re: Incorrect syntax near the keyword 'FROM' https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160674#M5404 <HTML><HEAD></HEAD><BODY><P>Have you tried breaking up the statement into smaller individual statements to see which section has the error?</P></BODY></HTML> Thu, 01 Oct 2015 21:21:06 GMT https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160674#M5404 JenniferMcCall4 2015-10-01T21:21:06Z Re: Incorrect syntax near the keyword 'FROM' https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160675#M5405 <HTML><HEAD></HEAD><BODY><P>Can you get it to work for a simpler expression (e.g. "<SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">EXTRACT(YEAR FROM <SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">"DateReported"</SPAN>)=2010</SPAN>")?</P></BODY></HTML> Thu, 01 Oct 2015 21:27:54 GMT https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160675#M5405 DarrenWiens2 2015-10-01T21:27:54Z Re: Incorrect syntax near the keyword 'FROM' https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160676#M5406 <HTML><HEAD></HEAD><BODY><P>What about moving the right-parenthesis over to before the less than comparison:</P><P></P><P>(EXTRACT(YEAR FROM CURRENT_DATE) - EXTRACT(YEAR FROM "DateReported")) &lt; 10 AND "Facility" = 'Main' AND ("Cause" = 'Other' OR "DateRepaired" IS NULL)</P></BODY></HTML> Fri, 02 Oct 2015 00:50:16 GMT https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160676#M5406 JoshuaBixby 2015-10-02T00:50:16Z Re: Incorrect syntax near the keyword 'FROM' https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160677#M5407 <HTML><HEAD></HEAD><BODY><P>Tried that and I'm getting the same error.</P></BODY></HTML> Fri, 02 Oct 2015 03:31:37 GMT https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160677#M5407 ChrisPolley 2015-10-02T03:31:37Z Re: Incorrect syntax near the keyword 'FROM' https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160678#M5408 <HTML><HEAD></HEAD><BODY><P>Yes and no</P></BODY></HTML> Fri, 02 Oct 2015 03:32:09 GMT https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160678#M5408 ChrisPolley 2015-10-02T03:32:09Z Re: Incorrect syntax near the keyword 'FROM' https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160679#M5409 <HTML><HEAD></HEAD><BODY><P>do the following and tell if it works</P><UL><LI><SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">(EXTRACT(YEAR FROM CURRENT_DATE))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - note the brackets!</SPAN></LI><LI><SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">((EXTRACT(YEAR FROM CURRENT_DATE) - EXTRACT(YEAR FROM "DateReported"))&nbsp; &lt; 10 )&nbsp;&nbsp;&nbsp; - ditto!!</SPAN></LI></UL><P><SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif;">If either fails, let us know which one... build the steps incrementally and manually watching that you may need to add brackets as I have done in the above 2 examples</SPAN></P><P>​</P></BODY></HTML> Fri, 02 Oct 2015 06:13:15 GMT https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160679#M5409 DanPatterson_Retired 2015-10-02T06:13:15Z Re: Incorrect syntax near the keyword 'FROM' https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160680#M5410 <HTML><HEAD></HEAD><BODY><P>It seems EXTRACT is working and CURRENT_DATE, is the issue with the DateReported field?&nbsp; Does this work?</P><UL><LI>(EXTRACT(YEAR FROM "DateReported"))</LI></UL></BODY></HTML> Fri, 02 Oct 2015 14:14:13 GMT https://community.esri.com/t5/geoprocessing-questions/incorrect-syntax-near-the-keyword-from/m-p/160680#M5410 JoshuaBixby 2015-10-02T14:14:13Z