+ Start a Discussion
RejonesRejones 

Workflow Field Update

Can anyone help me build a formula for a workflow field update? 

 

I have a field called Contract Expire Date and we have to send out a Renewal Notification a certian amount of days before this date.  I have a field called Renewal Notification Terms and my users will populate this as we get signed agreements based on the term days for example 90 days.

 

I need a formula that will take the Contract Expiration date and subtract the number of days indicated in the Renewal Notification field and populate the field called Communication Date.

 

For instance if the Expire date is 11/28/2011 and the Renewal Notification is 60 days i need the Communication Date to read 9/26/2011.

EalesieEalesie

Why not just use a time-based workflow with an associated workflow alert.