Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
OTBI: Diff of Two dates to get Age is rounded to next highest value — 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

OTBI: Diff of Two dates to get Age is rounded to next highest value

78
Views
3
Comments
edited Dec 21, 2018 11:37AM in General Transactional Reporting (OTBI) 3 comments

Summary

OTBI: Diff of Two dates to get Age is rounded to next highest value

Content

OTBI: Diff of Two dates to get Age is rounded to next highest value

Example: If difference of Age is 48.8 Its displayed as 49 instead of 48 even after using FLOOR or TRUNCATE.

Below is the formula I used still unable to succeed.

FLOOR(TimeStampDiff(SQL_TSI_YEAR, "Dependent Data"."Dependent Date Of Birth", Current_Date))

Your help is highly appreciated.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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