topic Re: Convert a dynamic variable to a date format in QlikView

Convert a dynamic variable to a date format

deekey2 — Fri, 29 Oct 2021 03:42:31 GMT

Hi All,

I'm trying to get a input field (vToday as below) and change it to dynamic variable(target to put to a dynamic table later)..

but somehow, the "29/10/2021" will convert to "0.00143.." as below

so I try to change the vToday to "44498", then the result is my expectation.

Can anyone help to find the solution, the expected input and output as below.

input :

output:

p.s. I have to get via dynamic var like $(vToday) so I can put to table for dynamic date range change, I tried to put vToday but the table hasn't updated :X

Thanks.

Dee

Re: Convert a dynamic variable to a date format

Lisa_P — Fri, 29 Oct 2021 04:34:06 GMT

If you want to keep the date in that format use vToday rather than $(vToday).

Using the $( ) tried to evaluate the contents so it divides 29 by 10 then by 2021 giving you 0.001434933....

Re: Convert a dynamic variable to a date format

Vegar — Fri, 29 Oct 2021 05:48:20 GMT

If you need to dollar expand your variable then you could try to quote it to force your string to be handled as a string, like this: '$(vToday)'