Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Date# resturn small decimal

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?

Tags (1)
2 Replies
Not applicable

Re: Date# resturn small decimal

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.

Luminary
Luminary

Re: Date# resturn small decimal

Hi, you should you this:

Let vTest = Date#(vMaxDateInQVD);

Don't use $ ( )

Community Browser