I have a Custom List in a SharePoint Services 3.0 which contains a date field.
This date field is an expire date for a contract (this may be one or two years in the future)
I would like the system to send an email two weeks before the expire date of the contract.
Normally I would use a workflow that triggers when a new item is added or modified, but I need the system to do a daily check thru all the records in the list and email if any of the dates falls within two weeks from Today.
Can this be done in WSS 3.0?
Thanks in advance