topic Technical question on EG query builder in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Technical-question-on-EG-query-builder/m-p/40735#M4880 <HTML><HEAD></HEAD><BODY><P>"between 01/01/2010 and 01/08/2010"&nbsp; is the same as&nbsp; 01/01/2010 &lt;= date &lt;= 01/08/2010</P></BODY></HTML> Thu, 22 Mar 2012 18:33:18 GMT Linlin 2012-03-22T18:33:18Z Technical question on EG query builder https://communities.sas.com/t5/SAS-Enterprise-Guide/Technical-question-on-EG-query-builder/m-p/40734#M4879 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Can anyone confirm the usage of the EG query builder? I am using the "between" type of operator inside a query builder to compare the dates. </P><P>Does the operator "between 01/01/2010 and 01/08/2010" convert to 01/01/2010 &lt; date &lt; 01/08/2010 or 01/01/2010 &lt;= date &lt;= 01/08/2010?</P><P></P><P>Thanks,</P><P>Raj.</P></BODY></HTML> Thu, 22 Mar 2012 18:17:24 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Technical-question-on-EG-query-builder/m-p/40734#M4879 saspert 2012-03-22T18:17:24Z Technical question on EG query builder https://communities.sas.com/t5/SAS-Enterprise-Guide/Technical-question-on-EG-query-builder/m-p/40735#M4880 <HTML><HEAD></HEAD><BODY><P>"between 01/01/2010 and 01/08/2010"&nbsp; is the same as&nbsp; 01/01/2010 &lt;= date &lt;= 01/08/2010</P></BODY></HTML> Thu, 22 Mar 2012 18:33:18 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Technical-question-on-EG-query-builder/m-p/40735#M4880 Linlin 2012-03-22T18:33:18Z Technical question on EG query builder https://communities.sas.com/t5/SAS-Enterprise-Guide/Technical-question-on-EG-query-builder/m-p/40736#M4881 <HTML><HEAD></HEAD><BODY><P> Thanks.</P></BODY></HTML> Thu, 22 Mar 2012 18:43:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Technical-question-on-EG-query-builder/m-p/40736#M4881 saspert 2012-03-22T18:43:03Z