# Qlik Sense App Development

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

## Strange behaviour of date function ??

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

1 Solution

Accepted Solutions
Not applicable

## Re: Strange behaviour of date function ??

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.

2 Replies
Not applicable

## Re: Strange behaviour of date function ??

No. try below

single quotes

='\$(=date(42620))'

Not applicable

## Re: Strange behaviour of date function ??

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.

Community Browser