I am currently trying to implement a constraint on a form that has two time variables (opening & closing hour). I would simply like to have a constraint on the closing hour so that it can't be earlier than the opening hour.
I have tried several lines in the "constraint" cell in the Excel file but can't get it to work properly.
Do you know which constraint should I write in order to achieve this result ?
Thank you very much in advance,
you can use this example:
timeConstraintTes.xlsx (9.8 KB)
Let me know if it solves your problem.
Hi @Grzesiek2010, I was searching for a solution to a similar problem and I am glad I bumped into this response.
I can confirm that this solves the problem.
@Grzesiek2010 thank you for providing the solution to this. I have tried using this same constraint, and it works perfectly in the app but for some reason it doesn't seem to work on the web version while I am testing. Please see screenshot below - no matter what time I put in the "End time" it still shows as an error.
I used the same constraint you suggested: decimal-date-time(.)>decimal-date-time(../start_time)
decimal-date-time() requires a dateTime. Use