adding alert on a Date Field

Question

I have a custom list containing Expire date field. I would like to get an alert (email) 30 days before the expire date for all items in the list. what is the best solution for that?

See also: http://sharepoint.stackexchange.com/questions/78760/sharepoint-task-list-with-email-alerts — Stu Pegg, Oct 04 '13 at 08:45

score 1 · Accepted Answer · answered Sep 26 '13 at 14:34

Write a timer job, which queries the list to get only items for which 30 days are left for expiry... And send alert for all such items!

For querying items you can use range of dates, programmatically add 30 days to current date and than use:

<Query>
  <Where>
    <And>
      <Geq>
         <FieldRef Name="ExpiryDate" />
         <Value IncludeTimeValue="FALSE" Type="DateTime">2011-01-01T15:55:52Z</Value>
      </Geq>
      <Leq>
         <FieldRef Name="ExpiryDate" />
         <Value IncludeTimeValue="FALSE" Type="DateTime">2011-01-31T15:56:29Z</Value>
      </Leq>
    </And>
  </Where>
</Query>

Timer job should run daily, maybe at the end of the day..

Thanks, Do you think a timer job will be best solution, what about a workflow or Information Management policy? — Medes, Sep 26 '13 at 14:54
Well you can try Workflows.. but Workflows may not be reliable AFAIK.. Timer job seems the best option ! — Arsalan Adam Khatri, Sep 27 '13 at 16:31

adding alert on a Date Field

1 Answers1