if Duration greater than 10 minutes

[Domearian]

I have a menu action. When that action is run, it will record the datetime that the user initiated that action. I don't want to be able to run that action again if it was within 10 minutes of it being run. Here is what I am using:

NOW()-LOOKUP(USEREMAIL(), User Administration, Email, Last Login)>="00:10:00"

It is running it everytime. What is the issue?

[Totocoss]

Can you try to put parentheses which surrounds the substraction. Like this : (NOW() - LOOKUP(USEREMAIL(), User Administration, Email, Last Login)) >= "00:10:00"

[Domearian · Accepted solution]

I actually managed to find another way:

NOW()>(LOOKUP(USEREMAIL(), User Administration, Email, Last Login)+“000:10:00”)

but I have put the same expression against a field of data:

[email] - Under the Show, I put the same expression and it no longer shows the item in the detail view of that data despite it being under the 10 minutes. Any reason why?

[Domearian]

Looking at it I think I know why, it should be <