I need to automaticlly update a date field by using Workflow capabilities
We created a contract and need to have a date field with "conteract's future end date"
This field should be calculated as followed:
1. as long as the contract is active
2. in the contract we have fields:
"first contract's terms" = (X number of months)
"adittional contract's terms" = (Y number of months)
3 once a contract is acivated:
"conteract's future end date" sould be "activation date + "first contract's terms"
4. as long as the contract is active, every time the "contract's future end date" = TODAY. the system shoud add to this date the "adittional contract's terms"
Can someone helop me in setting this up?
Thanks
Roee

I need to automaticlly update a date field by using Workflow capabilities
We created a contract and need to have a date field with "conteract's future end date"
This field should be calculated as followed:
1. as long as the contract is active
2. in the contract we have fields:
"first contract's terms" = (X number of months)
"adittional contract's terms" = (Y number of months)
3 once a contract is acivated:
"conteract's future end date" sould be "activation date + "first contract's terms"
4. as long as the contract is active, every time the "contract's future end date" = TODAY. the system shoud add to this date the "adittional contract's terms"
Can someone helop me in setting this up?
Thanks
Roee