You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Date calculation Logic

Accepted answer
26
Views
2
Comments
edited Mar 17, 2021 4:01PM in Planning 2 comments

Content

IN Oracle EPM cloud, we are trying to capture grant date(date format) via data form, now from these dates, we need to obtain the Amortization start date as below logic - i.e. 1st Jan of same Grant date year for few cases and for few cases - 1st Jan of one year prior to Grant date

1) How do we calculate these in business rules?

2) and how to obtain the number of months between the amortization start dates / end dates ? (just thinking to use - "NumberPeriods"=@CalcMgrMonthsBetween("Amortization start date", "Amortization end date");

3) any good pointers for date calculations?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!