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?
This seems to work when I use the date_function, however, my list boxes lose their values when I utilize it. For example my Year, Month and Day list boxes do not have any values in them.
