Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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?

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

SQL Select to Limit Dates

You should use to_date function:

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

- Ralf

3 Replies
MVP & Luminary
MVP & Luminary

SQL Select to Limit Dates

You should use to_date function:

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

- Ralf

Not applicable

Re: SQL Select to Limit Dates

Thank you!

Donna Lee

Oracle Applications Analyst

918-588-4761 Office

918-606-9891 Mobile

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

Not applicable

SQL Select to Limit Dates

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.