Compute Field for Age w/Decimals?

smodarressiyazdi

I'm trying to create a Compute/Derived Field in HR Talent to return an employee's age at hire with two decimals. If I set the field type to Decimal (e.g., 3.2), the calculation always returns 9.99 for every record, but without decimals the age calculates correctly.

I've tried formulas like:

• (StartDate - Birthdate) / 365
• ((StartDate - Birthdate) / 365)

I also tried computing age in days first (which returns correctly as an Integer and Numeric type) and then dividing by 365 in a separate field, but I get the same issue when decimals are involved.

What am I missing?

cleverly

Try increasing your Decimal size from 3.2 to 5.2. (Unless your organization exclusively hires kids under the age of ten, 9.99 is the largest two-digit decimal number you can write using a total of 3 numbers.)