Date value

[mokitsu61]

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') ?

[sunny_talwar]

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?

[mokitsu61 · Accepted solution]

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.