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 5.6.0.0.0 and laterInformation in this document applies to any platform.
Goal
On : 5.6.0.0.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?
Solution
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
| Goal |
| Solution |
| References |