I have joining date as a column in a list. |Based on joining date I need mails to be triggered 2 days before the given date.

2 Answers 2


Create 2 calculated columns:
1. One column to calculate joining date - 2 days. Like so: =[Joining Date]-2
2. Second column to extract the above difference in dd-mm (or mm-dd) format. Like so: =TEXT([Joining Date],"dd-MM")

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.

Refer this to get today's date and refer this to get the datepart.


You can use "Pause until date" activity of SharePoint designer Workflow.

For reference: Pause until date

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.