My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.