topic Re: Why definition query on date field is treated differently for two tables joining and three table joining? in ArcGIS Online Questions https://community.esri.com/t5/arcgis-online-questions/why-definition-query-on-date-field-is-treated/m-p/44187#M2135 <HTML><HEAD></HEAD><BODY><P>The above queries are for ArcSDE and SQL Server 2008 R2</P></BODY></HTML> Tue, 01 Mar 2016 19:45:44 GMT PeterLi1 2016-03-01T19:45:44Z Why definition query on date field is treated differently for two tables joining and three table joining? https://community.esri.com/t5/arcgis-online-questions/why-definition-query-on-date-field-is-treated/m-p/44186#M2134 <HTML><HEAD></HEAD><BODY><P>For ArcGIS 10.3.1 and SQL Server 2008 R2 environment, in the Definition Query of ArcMap:</P><P>When using two joining tables, the query can be simple:</P><P>table1.starting &gt; '2016-02-29 00:00:00'</P><P></P><P>However, using three joining tables, the query has to be the following for ArcGIS 10.3.1, but it doesn't work for ArcGIS 10.1:</P><P></P><P>table2.id2 &gt; 0 AND table3.id3 &gt; 0 AND table1.starting &gt; date'2016-02-29 00:00:00'</P><P></P><P>Why should they be different using date or not? Many simple queries by using Date work for two joining tables, but DO NOT WORK for three joining tables !!!</P></BODY></HTML> Tue, 01 Mar 2016 19:43:41 GMT https://community.esri.com/t5/arcgis-online-questions/why-definition-query-on-date-field-is-treated/m-p/44186#M2134 PeterLi1 2016-03-01T19:43:41Z Re: Why definition query on date field is treated differently for two tables joining and three table joining? https://community.esri.com/t5/arcgis-online-questions/why-definition-query-on-date-field-is-treated/m-p/44187#M2135 <HTML><HEAD></HEAD><BODY><P>The above queries are for ArcSDE and SQL Server 2008 R2</P></BODY></HTML> Tue, 01 Mar 2016 19:45:44 GMT https://community.esri.com/t5/arcgis-online-questions/why-definition-query-on-date-field-is-treated/m-p/44187#M2135 PeterLi1 2016-03-01T19:45:44Z