Creating a scheduled workflow which will fire alerts based on date variables
Afternoon. I'm trying to build a scheduled site workflow which looks at the start date of an employee in a list, then sends alerts if today's date is one month, three months or six months on from the start date. The alerts go to the employee or the employees manager depending on which of the criteria is hit.
Broadly speaking my approach has been: Query list.
Store results in variables
For each action on the list, Target Collection 'CollStartDate' store results in 'datStartDate'
Calculate dates 1 month/3 month/6month in parallel actions
Run If based on the dates above
The notification isn't firing and I'm floundering a bit. Has anyone built anything similar. All help gratefully appreciated!