erreur script

[#1]

Compta:

SELECT ACCOUNTED_CR,

date(LAST_UPDATE_DATE)

FROM APPS."GRAND_LIVRE_GENERAL"

where ledger_id in (2028,2030,2032,2026,2022,2024)

and LAST_UPDATE_DATE>=today();

[alexandros17]

Verify that in your SQL exists the function Today() otherways use Now()

Compta:

SELECT ACCOUNTED_CR,

date(LAST_UPDATE_DATE) as nyDate

FROM APPS."GRAND_LIVRE_GENERAL"

where ledger_id in (2028,2030,2032,2026,2022,2024)

and LAST_UPDATE_DATE>=NOW();

Let me know

[#3]

if you are using oracle the use and LAST_UPDATE_DATE>=SYSDATE

and if u are using sql server the use  and LAST_UPDATE_DATE>=now()

[maxgro]

Bold = sql: you have to use your database syntax (oracle, sql server, etc...); you can't use qlik functions here

Not bold = qlikview: you can use qlikview function (today, date, ....)

Compta:

load

     ACCOUNTED_CR,

     LAST_UPDATE_DATE

where

     .LAST_UPDATE_DATE >= ....

;   

SELECT ACCOUNTED_CR,

LAST_UPDATE_DATE

FROM APPS."GRAND_LIVRE_GENERAL"

where ledger_id in (2028,2030,2032,2026,2022,2024)

;

[#5]

// le problème n'est pas encore résolue

load *

where ACCOUNTING_DATE>=today();

select *

FROM APPS."GRAND_LIVRE_GENERAL"

where ledger_id in (2028,2030,2032,2026,2022,2024);

[maxgro]

did you get an error?

did you get 0 records?