Constraint - Comparing two "time" questions

Hello everyone,

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,

Hi @guillaume.pottier
you can use this example:
timeConstraintTes.xlsx (9.8 KB)

Let me know if it solves your problem.

Regards,
Grzegorz

4 Likes

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.

Thank you,
Dan

1 Like

Hi all,

@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.

image

I used the same constraint you suggested: decimal-date-time(.)>decimal-date-time(../start_time)

Any advice?

Many thanks,

Faran

decimal-date-time() requires a dateTime. Use decimal-time() instead.