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