Calculate number of DAYS between two dates in XX YEARS XX MONTHS XX DAYS format in OTBI — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Calculate number of DAYS between two dates in XX YEARS XX MONTHS XX DAYS format in OTBI

in Reporting and Analytics for HCM 1 comment

Summary:

We have a requirement in OTBI analysis to calculate the number of days between 2 dates in the following format – XX YEARS XX MONTHS XX DAYS.

We have tried some approaches by using the DATETIME functions in OTBI. However, the output is not correct for all the date ranges.

Most of the date ranges it gives the correct output but some cases the accuracy is getting missed by 1 or 2 days.

Content (please ensure you mask any confidential information):

We have a requirement in OTBI analysis to calculate the number of days between 2 dates in the following format – XX YEARS XX MONTHS XX DAYS.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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