topic Re: Date as variable in QlikView

Date as variable

HPW — Mon, 14 Feb 2022 14:31:06 GMT

Hello,

I'm setting in a script todays date as variable by using vLastRun=today(). In the list of variables the definition of the variable shows 14.02.2022, but .2022 of the definition is underlined in red. In the further script the usage of that variable leads to a syntax error. Already setting a new variable with the value of the first one by using vLastRun2=$(vLastRun) leads to the syntax error. Using the variable in a WHERE-clause is also not working.

It seems that the variable is not identified as date.

How I have to handle a variable to be used as date?

I guess there is as always an easy solution that I have not in mind as new user of QlikView.

Best regards

Re: Date as variable

hic — Mon, 14 Feb 2022 14:59:57 GMT

The statement
Let vLastRun=today()
will indeed assign a variable the date value. But then you need to use it properly.

The $(...) construction is a macro expansion, which means that if you write
Let vLastRun2=$(vLastRun);
the parser will see
Let vLastRun2=14.02.2022;
which is an incorrect syntax.

Try
Let vLastRun2=$(#vLastRun); // Force numeric value
or
Let vLastRun2='$(vLastRun)';
or
Let vLastRun2=vLastRun;
or
Let vLastRun2=Num(vLastRun);

See more on
https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849
https://community.qlik.com/t5/Qlik-Design-Blog/Data-Types-in-QlikView/ba-p/1474977

Re: Date as variable

HPW — Wed, 16 Feb 2022 07:57:10 GMT

Thanks for the quick reply and good solution.