topic Re: Today() into sql select in QlikView

Today() into sql select

Mon, 27 Aug 2012 17:37:52 GMT

Dear all,

is it possible to insert today() function into an sql select. For example:

sql select field1, field2, year from table1 where year < year(today());

I always get an error

Thanks for your help

Gr.

Mon, 27 Aug 2012 17:46:43 GMT

try using GETDATE()

mphekin12 — Mon, 27 Aug 2012 17:48:14 GMT

Try year(getdate()) instead.

Mon, 27 Aug 2012 19:57:32 GMT

Thanks very much. Is it right just for SQL SERVER or is it proper for ORACLE too ?

Gr.

mphekin12 — Mon, 27 Aug 2012 19:58:51 GMT

i'm using microsoft sql server. not sure if it is the correct syntax for oracle.

Mon, 27 Aug 2012 20:13:04 GMT

The GetDate() function is definitely the right answer in this case as suggested above.

However in some cases it may be needed to pass values from qlikview script to an sql statement.

Here's an example (something I've already used):

let vField1 = Peek('SystemField1',0,'RelatedTableFields');
let vField2 = Peek('SystemField2',0,'RelatedTableFields');

PropertyValues:
LOAD $(vField1), $(vField2);
SQL SELECT DISTINCT $(vField1), $(vField2) FROM $(vTableName);

Hope this will prove useful in future situations

Wed, 05 Dec 2012 10:17:43 GMT

Hi, for Oracle, try this:

sql select field1, field2, year from table1 where year < to_char(sysdate,'YYYY');

I hope that helps you.

Regards.

Zak