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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Age Formulas using SQL

edited Jan 28, 2021 2:29PM in Reporting and Analytics for HCM 9 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!