problem to load data in script for on deux rolling year

[pgarcia75]

Hello

I want to load datas contained in an ORACLE table database with a loading script on  2 rolling years

I tried this script:

LOAD
         date (DATETPT) as DATETPT_DTI, // Date of request
         REFDTI, // Unique number ref request (link to the table
...
SQL SELECT *
FROM PTAH.PCADTI WHERE PTAH.DATETPT <NOW () AND PTAH.DATETPT> DATE_SUB (NOW (), INTERVAL 2 YEAR);


When I start loading, I have a SQL error that tells me a bracket error on the right

PS:
The statement (without the WHERE clause) works

Thanks for your help

PATRICE

[Gysbert_Wassenaar]

Try replacing NOW() with SYSDATE or with CURRENT_DATE. Now() is a Qlikview function, which oracle doesn't understand.