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

[Chanty4u]

No. try below

single quotes

='$(=date(42620))'

[sunny_talwar · Accepted solution]

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.