3 Replies Latest reply: Oct 27, 2011 10:53 AM by dlee5853 RSS

    SQL Select to Limit Dates

      I have a load statement to load a table from Oracle. The SQL Select statement is such as:

       

       

      SQL SELECT *

      FROM APPS."XETA_POS_V"

      Where FINAL_INVOICE_DATE > '20051231';

      //Where "FINAL_INVOICE_DATE" Between'1-JAN-2010' and '2-JAN-2010';

      //Where "FINAL_INVOICE_DATE" ='1-JAN-2010';

       

      I cannot seem to limit my load to only the previous 2 years data. I am utilizing the FINAL_INVOICE_DATE field to check. However, somehow I keep getting 5 or 6 years worth of data. It is like it totally ignores my Where clause. What am I doing wrong?