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
Age Formulas using SQL — 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

Age Formulas using SQL

Received Response
29
Views
6
Comments
edited Jan 28, 2021 2:29PM in Reporting and Analytics for HCM 6 comments

Summary

Need age as of the current date and when someone will be a certain age

Content

Hello, 

I am needing a formula to calculate age in Years that does NOT round. For example, if someone's age is 38.6 as of the current date I don't want it to round up to 39. 

I am also needing a formula to calculate when someone will be 65. I can do the EDATE function in Excel but can't figure out what to use as a formula in SQL. 

Thanks!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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