Candidate Selection Process Action: Wait and auto-move on the future date

Summary:

We have a custom date field (EFF) on the Candidate Job Application.

• Recruiters enter a future date in this field (example: 29-Sep).
• The application is then moved to Phase X – State Y manually.
• We need an auto-move rule so that when today’s date becomes later than the EFF date (for example on 30-Sep), the system should automatically move the application to Phase X – State Z.

We created a Fast Formula that checks system date > EFF date.
The formula itself works, but the application does not stay “waiting” and auto-move on the future date.
It only moves if something else triggers a re-evaluation.