topic Desktop Query Syntax for Hosted Feature Layer in ArcGIS Online Questions https://community.esri.com/t5/arcgis-online-questions/desktop-query-syntax-for-hosted-feature-layer/m-p/760765#M37247 <HTML><HEAD></HEAD><BODY><P>I have a hosted feature layer in AGOL that I want to query from ArcMap (10.2.2) to find records where a date field occurs before another date field plus one year.&nbsp; When the data resides in a file geodatabase I can do this query using the following syntax:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14357656668083648 jive_text_macro" data-renderedposition="71_8_912_16" jivemacro_uid="_14357656668083648"><P>Date_Cert_Due &lt; Date_Work_Finished+365</P></PRE><P></P><P></P><P>This selects those records whose Date_Cert_Due is before the Date_Work_Finished plus one year.&nbsp; When I try to do the same query on my hosted feature layer the query looks very similar:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14357658779864554 jive_text_macro" data-renderedposition="171_8_912_16" jivemacro_uid="_14357658779864554"><P>"Date_Cert_Due" &lt; "Date_Work_Finished" + 365</P></PRE><P></P><P>When I verify the SQL, I get "There was an error with the expression."</P><P></P><P>I have tried using single quotes and no quotes and they didn't work.&nbsp; What am I missing?&nbsp; Can I do this type of query of a hosted feature layer from ArcMap on my desktop?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 01 Jul 2015 15:56:51 GMT JimW 2015-07-01T15:56:51Z Desktop Query Syntax for Hosted Feature Layer https://community.esri.com/t5/arcgis-online-questions/desktop-query-syntax-for-hosted-feature-layer/m-p/760765#M37247 <HTML><HEAD></HEAD><BODY><P>I have a hosted feature layer in AGOL that I want to query from ArcMap (10.2.2) to find records where a date field occurs before another date field plus one year.&nbsp; When the data resides in a file geodatabase I can do this query using the following syntax:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14357656668083648 jive_text_macro" data-renderedposition="71_8_912_16" jivemacro_uid="_14357656668083648"><P>Date_Cert_Due &lt; Date_Work_Finished+365</P></PRE><P></P><P></P><P>This selects those records whose Date_Cert_Due is before the Date_Work_Finished plus one year.&nbsp; When I try to do the same query on my hosted feature layer the query looks very similar:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14357658779864554 jive_text_macro" data-renderedposition="171_8_912_16" jivemacro_uid="_14357658779864554"><P>"Date_Cert_Due" &lt; "Date_Work_Finished" + 365</P></PRE><P></P><P>When I verify the SQL, I get "There was an error with the expression."</P><P></P><P>I have tried using single quotes and no quotes and they didn't work.&nbsp; What am I missing?&nbsp; Can I do this type of query of a hosted feature layer from ArcMap on my desktop?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 01 Jul 2015 15:56:51 GMT https://community.esri.com/t5/arcgis-online-questions/desktop-query-syntax-for-hosted-feature-layer/m-p/760765#M37247 JimW 2015-07-01T15:56:51Z