topic SQL Select to Limit Dates in QlikView

SQL Select to Limit Dates

Thu, 27 Oct 2011 14:20:09 GMT

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?

SQL Select to Limit Dates

rbecher — Thu, 27 Oct 2011 14:28:07 GMT

You should use to_date function:

...Where FINAL_INVOICE_DATA > to_date('20051231', 'yyyymmdd')

- Ralf

Re: SQL Select to Limit Dates

Thu, 27 Oct 2011 14:30:03 GMT

Thank you!

Donna Lee

Oracle Applications Analyst

918-588-4761 Office

918-606-9891 Mobile

donna.lee@xeta.com<mailto:@paetec.com

SQL Select to Limit Dates

Thu, 27 Oct 2011 14:53:59 GMT

Ralf,

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.