Page 1 of 1

Help on field Calendar extended

Posted: 02 Apr 2024, 20:01
by 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.
Calendar extended min date.jpg

Re: Help on field Calendar extended

Posted: 03 Apr 2024, 10:08
by 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

Re: Help on field Calendar extended

Posted: 04 Apr 2024, 23:46
by 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.