I need help with a site workflow based on the due date of tasks. The workflow would send a notification to the Assigned To person if a task is due soon or past due based on the due date
- Due date in 10 business days
- Due date in 3 business days
- Due date is 0 business days
- Due date is 5 business days past due date
- Due date is 10 business days past due date
- Due date is 15 business days past due date and daily after 15 business days
- Notifications are sent to the Assigned To person and they receive only one notification in a day
- Notifications to be sent at 4:00 each business day
- Project and Task status = In Progress
- The email notification contains a link, url, to the SharePoint Task List