topic Re: variable with Makedate not comparing to database date in QlikView

variable with Makedate not comparing to database date

leenlart — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have loaded a table from a database.

I would now like to select all the lines from that inital table where the date is equal to the last day of the previous month. For testing purposes, I set my date to

LET vMoisProvisions = MakeDate(2018,9,30);

Now my resident load does this :

resident Situations
where num(DATESIT) = num($(vMoisProvisions)) ;

The resident load is returning nothing.

My datesit looks like 43373 if I stick it in a text box or a list box.

If I do a text box with num($(vMoisProvisions)) I also get 43373.

When I put in the following line in my load script and debug I get 0,001651....

vMoisProvisions = num($(vMoisProvisions));

So what is going on here? How can I compare my vMoisProvisions to the DATESIT correctly?

Re: variable with Makedate not comparing to database date

Frank_Hartmann — Thu, 22 Nov 2018 17:10:30 GMT

Maybe this:

where num(DATESIT) = num('$(vMoisProvisions)') ;

Re: variable with Makedate not comparing to database date

leenlart — Fri, 23 Nov 2018 08:00:04 GMT

That works.

Thanks!

Now can you explain why this works ?

Re: variable with Makedate not comparing to database date

ckarras22 — Thu, 29 Nov 2018 06:28:23 GMT

It is needed to be enclosed in quotes as it is a date. Otherwise in Num() will be extracted something like 29/11/2018, which is a division. That's why you get such a number (0,001651).

Re: variable with Makedate not comparing to database date

leenlart — Thu, 29 Nov 2018 07:51:25 GMT

Hey,

Thanks so much for taking the time to explain this!