I have a requirement where I need to trigger a workflow without user interaction.
I created a workflow that sends an E-Mail notification to the Opportunity Owner if
Opportunity.CloseDate equals TODAY, which is working fine as long as the record is edited manually and closeDate is manually set to today's date.
My problem now is, that when I set the closeDate to somewhere in the future, two weeks for example, the workflow will not be triggered, because nobody edited the record.
How can I archieve a solution for this?
I found a quiet simillar question here, but this seems to be old and not following best practice. Is there a solution without apex?