Timestamp subtraction

[sspawar88]

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

[Gysbert_Wassenaar]

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() )

[#3]

Hi Satish,

You have to use expression in this way.

=Timestamp(Now()-Interval('5:30','mm:ss'))

Garry

[Kushal_Chawda]

try,

if(num#(interval(now()-Max(created_date) ,'mm')) <=5, red())

[MarcoWedel]

maybe also possible:

If(Max(created_date)>=Now()-'00:05:00', Red())

hope this helps

regards

Marco