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
41
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!