I have a document library which has a field for 'expiry date'. This field is not mandatory and is used for our Legal team to identify if the contract is close to expiring.
The Legal team would like to get an email reminder 30 days prior to the expiry date and then also 7 days prior to expiry date if no action has been taken.
What is the best way for me to implement a solution. I have been thinking of a workflow, but the expiry date may be a year or two in the future? Another thought has been to add an entry to a calendar and then send the email out from here.
I'd like to hear peoples views on their approach.