Complete Visual Studio Workflow State Programatically on a Specific Date

Hi All,

I have a requirement where I need to complete the workflow on a specific date. The workflow I designed is for a vacation workflow and need to have the workflow status as complete on the day the employee's vacation day starts. Is there any activity or a workflow timer job that would run on a specific time to compare now date with the date stored in a variable and then put the workflow state in a complete or In Progress state. I would prefer not to use a SPTimerJob with this and would prefer something within the workflow foundation.

Thanks in advance.