Interval issue

[Mahamed_Qlik]

Hi Guys,

I am trying to put if condition on below expression but it is not returning correct result:

=if((interval((ACTION_DATE)- WeekStart((ACTION_DATE)) , 'hh'))>=24,'True','False')

So whenever the interval results (Number of hours only) between these two dates are greater than equal to 24 it should return as 'True' else 'False'

[MayilVahanan]

Hi

Is it Action date field contains time stamp? if not, you can try with days instead of hh like

if((interval((ACTION_DATE)- WeekStart((ACTION_DATE)) , 'd'))>1,'True','False')