Default start date in DFF for an Employee from Value set Table

Summary:

We are trying to default a DFF with Start date of an Employee instead of entering date manually. We tried using SQL in Value Set to default the date but we found that the expected value is displayed as Drop down.

Though the expected date is shown, it is not defaulted and we need to choose the displayed date.

Can anyone suggest to default DFF from Value Set (dynamic date).

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):