topic Strange behaviour of date function ?? in App Development

Strange behaviour of date function ??

bertrand_herard — Thu, 15 Sep 2016 14:00:42 GMT

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

Chanty4u — Thu, 15 Sep 2016 17:02:06 GMT

No. try below

single quotes

='$(=date(42620))'

sunny_talwar — Thu, 15 Sep 2016 17:02:16 GMT

Dollar sign expansion is taking the date and converting it into a division calculation

=$(=Date(42620)) -> $(=07/09/2016) -> which is saying 7 divided by 9 divided by 2016.