Valid If Entry Duration Is Greater Than

Hi, I was having a difficulty in expression. I would like to limit the entry if the latest [time in] for every vehicle([nopol]) can only be entry after 10 minutes. Thank you.

Screenshot 2023-07-26 090414.pngScreenshot 2023-07-26 091606.png

Screenshot 2023-07-26 092202.png

0 4 65
4 REPLIES 4

Where are you putting this expression?

Remove the MINUTE() portion. datetime minus datetime = duration, you need to compare like against like. And you probably mean "000:10:00", because "000:00:02" is 2 seconds.

 

I thought the expression was already correct, but I was still able to choose the vehicle number even thought the time is under 7 minutes, which is 15 seconds.
Screenshot 2023-07-27 104326.pngScreenshot 2023-07-27 104342.png


I was still able to choose the vehicle number

Like from a dropdown? Did it show invalid value error after choosing it?

 

Yes, from an enum dropdown. It must show an error if the duration is below 7 minutes, but I was still able to choose it.

Top Labels in this Space