Discussion Board for collaboration on QlikView Scripting.
I am working on the for next loop on the date. And want to convert the date to number.
Let vYesterday = Num(Today(1)-1);
Let vMaxDateInQVD = Date($(vYesterday)-10);
Let vTest = Date#($(vMaxDateInQVD));
but the returns are:
Why the vTest is a small decimal? I suppose it should be an integer likes vYesterday - 10
Is there anyone help?
I change it to:
Let vTest = Date#('$(vMaxDateInQVD)');
Added two single quot, it seems work now if I use Num function.
Hi, you should you this:
Let vTest = Date#(vMaxDateInQVD);
Don't use $ ( )