Problem interpreting a command in a script

Wed, 06 Jun 2012 07:46:15 GMT

Hi,

I try to use this Script:

LET v_Date_for_Update = date(today(),'YYYY-MM-DD');

bi_report:

LOAD * FROM "QVD_Files\QVD_DMG.qvd" (qvd)

where interval < $(v_Date_for_Update);

Where interval represents date in this format 'YYYY-MM-DD' (e.g. '2012-06-06').

It seems that the command interval < $(v_Date_for_Update) isn't interpret as i meant, say: interval < '2012-06-06' (with apostrophes)

but as interval < 2012-06-06, and therefore no record is returned.

How can i cause QlikView to interpret in the right way?

Thanks,

Guy

Re: Problem interpreting a command in a script

vincent_ardiet — Wed, 06 Jun 2012 08:11:42 GMT

Hi Guy,

You have the answer, just put quotes around the call of the variable : interval < '$(v_Date_for_Update)'

Regards,

Vincent