3 Replies Latest reply: Aug 12, 2013 11:11 AM by Heino Juho RSS

    Trouble with IF-statement

    Heino Juho

      Hi,

       

      my rule is that if a record for a certain day (say, 12.8.2013 which is 41498 in number format) is already contained in the field NumericDate, no further action needs to be done. If the record is not contained, some calculations should be done.

       

      The problem is that the IF is not working like it should [that is, if I created it correctly]: the qvd Testi1 contains the value of the variable (=41498) in the NumericDate-field. Still, the screen captures (left showing execution of the statement and right showing that the condition of the IF did not work as expected because execution went into ELSE-part) indicate that something is wrong.

       

      Can someone think of an error in the IF-statement?

       

       

      Any help appreciated,

       

      Juho

       

      1.PNG2.PNG