I created a scheduled site workflow for a list. That will send a notification in 90 days from the effective date.
- Action set
- Calculated date (90 days ago)
- Query list
- Filtered by effective date which equals my variable
- Type of action "new"
- Status "Employee
- For each
- Email notification
- So the workflow looks at the effective date, status and type of action
- I need to also add logic that says if the employee has been type of action "Termed" within the 90 days then do not send the notification
Help? Do i add another query list within the for each?