Set renewal date to 30 days before contract end date?

  • 1
  • Question
  • Updated 4 months ago
I am looking to have renewal date in the customer section to by 1 day before the contract start date of the most recent renewal opportunity open.

Is there a way I can create a rule to update this? If so, what does this rule look like?
Photo of Tony Tao

Tony Tao

  • 546 Points 500 badge 2x thumb

Posted 4 months ago

  • 1
Photo of Tim Schukar

Tim Schukar, Employee

  • 1,420 Points 1k badge 2x thumb
Hey Tony - 

Do you mean adding a field to the Customer Info object and populating it with a calculated date that is based on the contract start date?

If so, the rule would look something like this:

1. Pull dataset of all contracts with contract start date and account SFDC ID.

2. Transform the dataset to create a calculated "Renewal Date" field of Contract Created Date - 365 (or 366 for leap year).   (This assumes you want to populate the previous renewal date.  Add 365 or 366 if you want to populate the NEXT renewal date).

3. Use Load to SFDC Object and target the Customer Info object "Renewal Date" field with the calculated field from step 2.

4.  Pull this "Renewal Date" field into the C360 (or other location as desired)

Let me know if you have any other questions?  Thanks!

Photo of Tony Tao

Tony Tao

  • 546 Points 500 badge 2x thumb
Hey Tim, Thanks for the response. Is it an expression or function when creating the calculated field, and is function, what type?