https://community.qlik.com/t5/App-Development/Calculated-Dimesnion-using-now-function/m-p/1740118#M56648 <P>Hi,</P><P>On Qlik April 2020 I am using the below as calculated Dimension to fetch date within 12 hours</P><P>=if([60 Min Granularity]&gt;=Floor(now()-6/24,1/24) and [60 Min Granularity]&lt; ceil(now()+ 5/24,1/24),([60 Min Granularity]))</P><P>This is working , but next day it won't be working. If&nbsp; I make any change to the formula like adding some unwanted brackets, it will work again, but for a day .Seems to me like some caching issues.</P><P>I have tried with different timer-mode also like now(1) and now(2).</P><P>Can anyone please check if I am doing the right thing.</P> Sat, 16 Nov 2024 18:10:07 GMT fabdulazeez 2024-11-16T18:10:07Z https://community.qlik.com/t5/App-Development/Calculated-Dimesnion-using-now-function/m-p/1740118#M56648 <P>Hi,</P><P>On Qlik April 2020 I am using the below as calculated Dimension to fetch date within 12 hours</P><P>=if([60 Min Granularity]&gt;=Floor(now()-6/24,1/24) and [60 Min Granularity]&lt; ceil(now()+ 5/24,1/24),([60 Min Granularity]))</P><P>This is working , but next day it won't be working. If&nbsp; I make any change to the formula like adding some unwanted brackets, it will work again, but for a day .Seems to me like some caching issues.</P><P>I have tried with different timer-mode also like now(1) and now(2).</P><P>Can anyone please check if I am doing the right thing.</P> Sat, 16 Nov 2024 18:10:07 GMT https://community.qlik.com/t5/App-Development/Calculated-Dimesnion-using-now-function/m-p/1740118#M56648 fabdulazeez 2024-11-16T18:10:07Z