Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

1 Answer

up vote 1 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
add comment

Your Answer

 
discard

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.