Date Difference - Not Getting Decimal Value Only Integer Which Ignores Days
(Doc ID 2822879.1)
Last updated on NOVEMBER 22, 2021
Applies to:Oracle Insurance Insbridge Rating and Underwriting - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.0 version, RateManager
Date Difference - not getting decimal value only integer which ignores days
We are trying to calculate date difference in months. However, its ignoring days.
For Example, difference between 07/19/2017 and 207/30/2019 is 24 months and 12 days. In SR we are getting integer value which is 24 and its ignoring 12 days.
We have factors for 1-12,12-24 and 24+ months. In the above scenario it should get 24+ factors. However, its using factor for 12-24 as we are getting 24 instead of 24 Bu we are expecting 24.37, we can achieve this in excel by using YEARFRAC("07/19/2017","07/30/2019")*12.
Is there any way we can do that in SoftRater?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document