topic Re: Date# resturn small decimal in QlikView

Date# resturn small decimal

Wed, 29 May 2013 15:53:26 GMT

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?

Wed, 29 May 2013 16:01:25 GMT

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 — Wed, 29 May 2013 16:03:50 GMT

Hi, you should you this:

Let vTest = Date#(vMaxDateInQVD);

Don't use $ ( )