Check if time taken is more than hour

[#1]

Hi All.

Please check the below expressions

=interval(Timestamp(reloadtime())-Timestamp(DateTimeLeadCreatedOn),'hh')

This gives the interval in hours.

If the above expression is greater than 1 it has to return success otherwise failure.

=if(interval(Timestamp(reloadtime())-Timestamp(DateTimeLeadCreatedOn),'hh')>1,'Success','Failure')

But the below expression is not returning anything.

Can someone help me with this issue.

Regards,

Keerthi KS

[raajaswin]

Can you post sample data and app?

[Anonymous]

may be this:

=if(num(interval(Timestamp(reloadtime())-Timestamp(DateTimeLeadCreatedOn),'hh'))>1,'Success','Failure')

[#4]

When its converting to num it gives some different value in decimals.

[tamilarasu]

Probably,

=If(Interval (Timestamp(reloadtime())-Timestamp(DateTimeLeadCreatedOn),'hh:mm')<'01:00','Success','Faliure')

[tresesco · Accepted solution]

Try like:

=if(reloadtime()-DateTimeLeadCreatedOn>1/24,'Success','Failure')

[Anonymous]

Nope, I am just making your Interval as a num while comparing with 1....

It would return you either Success or Failure

[VishalWaghole]

Hi Keerthi,

Make sure you provide specific timestamp format, Try this one

=if(interval(Timestamp(reloadtime(),'MM/DD/YYYY h:mm:ss TT')-Timestamp(DateTimeLeadCreatedOn,'MM/DD/YYYY h:mm:ss TT'),'hh')>1,'Success','Failure')

[MK_QSL]

IF(TimeStamp(ReloadTime()-DateTimeLeadCreatedOn)*24>1,'Success','Failure')