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.
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.
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.
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |