Hi
Running APEX 21.1.2 (cloud)
We need to set a minimum date for one of our Date Picker fields, and have achieved this by setting the Minimum Static date to -0d as demonstrated in the image below:
This prevents the user from selecting any date in the past for Hiredate and works well on insert. (demonstration details below)
However, when I then attempt to update any other page items for a record with a Hiredate already set previously in the past, I will get the following error: Hiredate must be on or after 28-Sep-2021. (replace the date with today's date)
This is because the Hiredate is being evaluated before the user Saves by -0d even when I'm not making changes.
One way to get around the problem, is to move my validation out of the Date Picker settings and only in the validating process, however we don't want the user to ever have the option of selecting an incorrect date. We don't want to validate at the point of Save only.
We also don't want to make the HireDate readonly.
Any idea of how to get around this problem, please?
-- Demo --
Page 5: Interactive Report
Workspace: af_plays
Login: demo / _af_plays
To demo: Edit an existing employee record by clicking on the employee number hyperlink. Edit the salary on the modal window. The Hiredate will give an error message.
Thanks,
Annelize