topic Problem with loadscript (WHERE-command with date-function) in QlikView

Problem with loadscript (WHERE-command with date-function)

newqlikie — Fri, 20 Jul 2012 06:15:50 GMT

Hi everybody,

I have following script:

LET vDate = addmonths(num(today()), -7);
 LOAD *, JATEIHNR&'.'&JATEIUNR as TNNR00;
SQL SELECT JATEIHNR,
    JATEIUNR,
    JAAUFNR as "Auftragsnummer",
    JARECDAT,
    JAARTNR as DUREF,
    JALIEMEN
FROM QS36F.DLSJA
    WHERE JALIEMEN>0 and JARECDAT>$(vDate);

When I run the script, i get following script error:

The prompted date (yellow highlited) is absolutely ok, but I get that error.

What do I do wrong?

Thanks for your help.

Regards

NewQlikie

Re: Problem with loadscript (WHERE-command with date-function)

sbaldwin — Fri, 20 Jul 2012 07:16:43 GMT

Hi, can't quite make out the error but i have had these kind of errors with dates, try to add quotes round your dollar expansion ie:

WHERE JALIEMEN>0 and JARECDAT>'$(vDate)';

this is also assuming your DB accepts the format you are passing it, again can't properly make out the error to confirm.

Thanks

Steve

Re: Problem with loadscript (WHERE-command with date-function)

newqlikie — Fri, 20 Jul 2012 07:35:51 GMT

Hi Steve,

thank you very much.

"Sometimes the easiest way is direct in front of you, but you can not see it!"