variable with Makedate not comparing to database date

[leenlart]

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?

[Frank_Hartmann · Accepted solution]

Maybe this:

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

[leenlart]

That works.  

Thanks!

Now can you explain why this works ?  

[ckarras22]

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). 

[leenlart]

Hey, 

Thanks so much for taking the time to explain this!