Subtraction two dates on a form

1

Hi Darek,

in the "on value change" of both date fields on tab "style and behaviour" of both fields add a rule that sets the value of the field you want to display the delta in. In my case the difference between reservation start and reservation end will be put into the field item to be reserved.

See screenshot below.

Good luck with webcon! :)

It's so simple:) I tried in the same way but not on the dates but on the calculated field. Works great but there is one more thing. I also got error messege:"Incorrect operation. Value cannot be converted to date." Can you help?

Hi again, problem most likely is that always one field is empty, which will cause trouble with date functions. so you need to make sure you only calculate the datediff when both fields have values. Didn't think of that :) See screenshot below.

Great! Works good now. Thank you very much:)