how to enable free-form date entry while still enforcing the date validation

Summary:

Hi Team,

We have created a DFF segment at the project level with the data type set to Date and mapped it into one of the available date columns. For the Value Set, we have defined it as a Table-type Value Set with the Value Data Type as Date.

We have a requirement to stop user to enter future date like they should enter future date which greater than sysdate, below is the query we used to allow users to view and select date values up to the system date:

(SELECT TO_DATE('01-10-2020','DD-MON-YYYY') + LEVEL - 1 AS DTVAL