topic erreur script in QlikView

erreur script

Mon, 23 Jun 2014 11:39:24 GMT

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();

Re: erreur script

alexandros17 — Mon, 23 Jun 2014 11:49:30 GMT

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

Re: erreur script

Mon, 23 Jun 2014 11:55:19 GMT

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()

Re: erreur script

maxgro — Mon, 23 Jun 2014 12:18:06 GMT

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)

;

Re: erreur script

Tue, 24 Jun 2014 08:31:25 GMT

// 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);

Re: erreur script

maxgro — Tue, 24 Jun 2014 11:14:45 GMT

did you get an error?

did you get 0 records?