topic Re: Getting a Date & Time Value from Commandline in QlikView

Getting a Date & Time Value from Commandline

Anonymous — Tue, 28 Aug 2012 14:13:04 GMT

Hi all,

I have the following problem and any advise would be welcome.

I am forwarding two variable via batch:

qv.exe /r /vschmat_datum_tmp=%date% /vschmat_zeit_tmp=%time% my.qvw

These variables are shown in an input box of my qvw after execution of the batch thus transmission is working.

schmat_datum_tmp 28.08.2012

schmat_zeit_tmp 14:48:55,85

In the loadscript I wanted to combine these to variables to a timestamp like this:

let schmat_tmp=timestamp(date($(schmat_datum_tmp)) + time($schmat_zeit_tmp,'hh:mm')) ;

It always runs into an error message during script execution. I thought the time ms might be the cause thus I tried the following:

let schmat_tmp=date($(schmat_datum_tmp));

But this causes the same Error again.

Any idea what is wrong?

Regards,

Schmat

fosuzuki — Tue, 28 Aug 2012 15:20:52 GMT

Maybe if you try:

let schmat_tmp = timestamp(date('$(schmat_datum_tmp)') + time('$(schmat_zeit_tmp)','hh:mm')) ;

rwunderlich — Tue, 28 Aug 2012 15:44:32 GMT

You'll need the # versions of the functions to read the values.

let schmat_tmp = timestamp(date#('$(schmat_datum_tmp)') + time#('$(schmat_zeit_tmp)','hh:mm'))

Anonymous — Wed, 29 Aug 2012 09:50:17 GMT

Edit:

Its working now:

Using the following Code:

let schmat_tmp = timestamp(date('$(schmat_datum_tmp)')+ time(left('$(schmat_zeit_tmp)',5)));

Thx for your help.