topic Definition Query to get the records added in the last six months in Mapping Questions https://community.esri.com/t5/mapping-questions/definition-query-to-get-the-records-added-in-the/m-p/461591#M5038 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><SPAN>I am trying to write a definition query on a points file on an Oracle DB. I want to retrieve records added in the last six months. So far, I have written the following:</SPAN><BR /><BR /><SPAN>MONTHS_BETWEEN (SYSDATE, TO_DATE ( DATE_CREATED, 'DD/MM/YYYY')) &lt;6</SPAN><BR /><BR /><SPAN>This doesn't return any rows at all.</SPAN><BR /><BR /><SPAN>I have also tried this code:</SPAN><BR /><BR /><SPAN>SYSDATE - DATE_CREATED &lt; 185</SPAN><BR /><BR /><SPAN>This works to a certain extent but it is not precise.</SPAN><BR /><BR /><SPAN>Can anyone please help me find a solution to this?</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Fri, 25 May 2012 09:28:41 GMT YousafHassan 2012-05-25T09:28:41Z Definition Query to get the records added in the last six months https://community.esri.com/t5/mapping-questions/definition-query-to-get-the-records-added-in-the/m-p/461591#M5038 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><SPAN>I am trying to write a definition query on a points file on an Oracle DB. I want to retrieve records added in the last six months. So far, I have written the following:</SPAN><BR /><BR /><SPAN>MONTHS_BETWEEN (SYSDATE, TO_DATE ( DATE_CREATED, 'DD/MM/YYYY')) &lt;6</SPAN><BR /><BR /><SPAN>This doesn't return any rows at all.</SPAN><BR /><BR /><SPAN>I have also tried this code:</SPAN><BR /><BR /><SPAN>SYSDATE - DATE_CREATED &lt; 185</SPAN><BR /><BR /><SPAN>This works to a certain extent but it is not precise.</SPAN><BR /><BR /><SPAN>Can anyone please help me find a solution to this?</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Fri, 25 May 2012 09:28:41 GMT https://community.esri.com/t5/mapping-questions/definition-query-to-get-the-records-added-in-the/m-p/461591#M5038 YousafHassan 2012-05-25T09:28:41Z Re: Definition Query to get the records added in the last six months https://community.esri.com/t5/mapping-questions/definition-query-to-get-the-records-added-in-the/m-p/461592#M5039 <HTML><HEAD></HEAD><BODY><SPAN>Did you ever figure this out?&nbsp; I have a join in my mxd and trying to query anything with a join using sysdate is giving me an error.</SPAN></BODY></HTML> Thu, 23 May 2013 14:06:25 GMT https://community.esri.com/t5/mapping-questions/definition-query-to-get-the-records-added-in-the/m-p/461592#M5039 JustinCornell 2013-05-23T14:06:25Z