I have a problem that I can't find a proper solution. I have a list in SharePoint 2010 and one of the columns is Date Expiration. The thing is that I want to send an email to a user when this date is overdue.

The problems I'm facing are mainly:

  • Send this notification even when the record is not updated
  • I can't use today variable in a formula column

Any suggestions?

2 Answers 2


In such case you have to create custom timer job and schedule it to run in every few moments.

Best ever article to learn How to create timer job in SP 2010

Using workflow:

Create a workflow and use while activity and create your logic here.

For example see this answer.

Configure the workflow and start it manually for the first time.

For more reference you can read answers to this post to get more clear ideas.

  • Thanks a lot guys for the suggestions but I'm a bit limited here. I'm only allowed to use out-of-the-box features (including workflows)...
    – Joseph
    Commented Jun 28, 2017 at 7:29
  • Thanks Aakash. I tried this but when I type While Statement, designer says No results in red
    – Joseph
    Commented Jun 28, 2017 at 8:52

Write a timer job and check the condition with the Date Column, If that matches , send an email else no action

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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