Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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:
vTest "0.00013799194127063"
vMaxDateInQVD 5/18/2013
vYesterday 41422
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 vYesterday = Num(Today(1)-1);
Let vMaxDateInQVD = Date($(vYesterday)-10);
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 $ ( )