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
Skip to content
  • 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!