topic Date value in QlikView

Date value

mokitsu61 — Thu, 10 May 2018 07:17:54 GMT

Hi,

LET value1 = Num('2016/04/01'); // 42461

LET value2 = Date#('2016/04/01', 'YYYY/MM/DD'); // 504

I don't know why value of 2nd line is not 42461 but 504('1901/04/01') ?

Re: Date value

sunny_talwar — Thu, 10 May 2018 15:37:52 GMT

I think the second one is getting evaluated when you use $(value2) which is leading to a calculation 2016/4 = 504. What exactly are you trying to do here with the variable? Why do you need it to be in particular format?

Re: Date value

mokitsu61 — Fri, 11 May 2018 01:07:04 GMT

Thank you for your replying.

It's fixed by rebooting my machine few times.

I'm using QlikView Desktop on 8G memories and sometimes it is not working stable.