2 Replies Latest reply: Sep 15, 2016 1:02 PM by Sunny Talwar RSS

    Strange behaviour of date function ??

    Bertrand HERARD

      Hello,

      in (at least) QlikView 11.2 SR 9 x64, In any QlikView application (even a new one), Can someone explain me  why :

       

      in an expression, if you put =date(42620), you will get 07/09/2016 (that is normal).

      BUT if you put =$(=date(42620)), you will 0,0003858024691358   ??

      Where does come this decimal number ? I thought the date function transforms a number of days into

      a date ?

       

       

      Best regards