Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
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')