SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a calendar list in which to post deadlines. I need a reminder to be sent out two weeks before the deadline, so I am trying to put in a retention policy. To measure the date to activate this retention stage I have created a calculated column that removes 14 days from the end time. This works fine, however, I cant see this column as an option to activate the retention stage. Am I missing something? Thanks.

share|improve this question
up vote 2 down vote accepted

No you're not. Retention policies won't recognise a calculated date even if it's set to date/time format.

A good way around this is to shift the date calculation into SharePoint Designer. Use the "Add Time to" action to subtract 14 days (-14) from your deadline day and output this to a variable. In the next step, pause the workflow until then and your workflow will wait until then to trigger.

You'll have to compose the email also in the last step but I've always found this an effective workaround.

share|improve this answer
Thank you very much for helping. – Charles Baker Feb 14 '13 at 8:56
Quick question: Is this best practice even for a list with hundreds of items? I'm not doubting you, just want to make sure I wont be causing other issues! – Charles Baker Feb 14 '13 at 8:57
The community will be able to answer that one from thier own experiences I hope. I've used this in high volume lists myself with no real concerns. – Steven D Andrews Feb 14 '13 at 9:05
This seems to work really well. Thanks for your help. – Charles Baker Feb 26 '13 at 14:17
What will happen if someone modify the deadline later? Will the pasued workflow aware the change and update this parameter? – Mark Jul 30 '15 at 8:30

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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