Date# resturn small decimal

[#1]

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?

[#2]

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.

[jvitantonio]

Hi, you should you this:

Let vTest = Date#(vMaxDateInQVD);

Don't use $ ( )