Help on field Calendar extended

[techtr]

Using field type "Calendar extended", I am trying to specify that field_441 cannot be earlier than field_440 in the same entity, i.e. min selectable date for field_441 is field_440. I am using the example given but it is not working. I don't know what I am doing wrong. Can you please assist? Thank you.

[support]

I think you have to select max possible value https://www.w3schools.com/sql/func_mysql_max.asp

So try

Code: Select all

select max(field_440) as field_440  from app_entity_27

[techtr]

Thank you. It is working but not as intended. A. Since it is on the backend (on the database) I guess it is not preventing the user to enter unintended value on the form and saving without any warning. B. It is skipping the Sat+Sun by default.