joining date as a column in a list. |Based on joining date I need mails to be triggered 2 days before the given date.
Create 2 calculated columns:
1. One column to calculate joining date - 2 days. Like so:
2. Second column to extract the above difference in dd-mm (or mm-dd) format. Like so:
In the workflow, format today's date as dd-mm or mm-dd and compare it with the 2nd column. If it is similar, send an email.
You can use "Pause until date" activity of SharePoint designer Workflow.
For reference: Pause until date