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.
Help on field Calendar extended
- support
- Site Admin
- Posts: 6216
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Help on field Calendar extended
I think you have to select max possible value https://www.w3schools.com/sql/func_mysql_max.asp
So try
So try
Code: Select all
select max(field_440) as field_440 from app_entity_27
Re: Help on field Calendar extended
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.