Time validation

[Grzesiek2010]

Hi @godlove

you can just use constraint, here is a sample form:

Create constraint for time

Hi @guerrilla, See the attached file to find the time constraint you wanted. The time in files are custom, you can explicitly put the decimal times you want. TimeConstraint.xlsx (11.9 KB)

If it's not a Time question you can also use this sample

Constraint for date/time

This behavior is a little tricky, but here goes... now() will give you a timestamp and you'll need to wrap it with once() if you don't want the form to constantly re-evaluate it. Once you have that, you can use format-date-time(${now_string}, '%H') to grab the hour and format-date-time(${now_string}, '%Y') to grab the year. You then use those in the constraints. I've attached an example. If the behavior is not what you want, try removing the once() part. Yaw datetime_constraint.xlsx (11…