Restrict form save

Hello, I'm creating an application for timekeeping. It has two tables, an employee table and another record table. The employee table has the entry time of each employee. I would like to restrict registration to 15 minutes before check-in time and 15 minutes after check-in time. For example: if entry is at 07:00, the employee could only register from 06:45 until 07:15. Can anyone help me, thank you in advance.

Solved Solved
0 2 100
1 ACCEPTED SOLUTION

Try VALID IF = 

AND(
TimeNow()>=[CheckInTime]-"000:15:00",
TimeNow()<=[CheckInTime]+"000:15:00"
)

View solution in original post

2 REPLIES 2

Try VALID IF = 

AND(
TimeNow()>=[CheckInTime]-"000:15:00",
TimeNow()<=[CheckInTime]+"000:15:00"
)

Thank you very much, it worked.

Top Labels in this Space