CRM On Demand - Administration (MOSC)

MOSC Banner

How do we calculate the duration between contract Start Date and Contract End Date?

edited Jun 29, 2015 12:17PM in CRM On Demand - Administration (MOSC) Question

Hi,

We have a workflow that is supposed to calculate a contract duration (nber of months) based on the contract start and end date.

And another workflow that is supposed to calculate the End Date based on the duration.

The Workflows calcualtions are approximate and we do not get the right date:

See below what we have:

-------------

When new record saved:

([<iDuration_of_the_Contract_ITAG>] IS NOT NULL AND [<dContract_End_Date_ITAG>] IS NULL)

Then action is update field:

([<dStart_Date_ITAG>]+( [<iDuration_of_the_Contract_ITAG>]*30))+([<iDuration_of_the_Contract_ITAG>]/2)- ([<iDuration_of_the_Contract_ITAG>]/12)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center