Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In table object consist ID's
if i want to check whether this ID is updated in last 5 min or not..if this is not updated i want to show in red().
is this expression correct ?
if(Max(created_date)<> Max(created_date)- 5/(24*60) ,red())
Max(created_date) is 7/8/2015 11:57:31 PM
Max(created_date)<> Max(created_date)- 5/(24*60)
That condition will always be true.
Maybe like this: if(Max(created_date) >= now() - 5/(24*60), red() )
Hi Satish,
You have to use expression in this way.
=Timestamp(Now()-Interval('5:30','mm:ss'))
Garry
try,
if(num#(interval(now()-Max(created_date) ,'mm')) <=5, red())
maybe also possible:
If(Max(created_date)>=Now()-'00:05:00', Red())
hope this helps
regards
Marco