Age calculation

[TyGuy]

You can also do it by adding the Round function to your existing calculation.

[Brown]

Can someone please tell me how to figure chronological age using the current date and limiting the outcome to one decimal point?

i.e. 12.1 yrs old

Am using the formula {today - dob}/365.25

However, I end up with a figure with 6 decimal points. i.e. 12.123455 yrs. old

Thanks!

[WBlanchard]

Fairly easy. In Layout mode, select the age calc field and then select Format/Number and select Format as decimal and set number of decimals to 1

HTH

[BruceJ]

Caution withteh Round function... you'll end up adding a yearont someone's age when they are less than 6 months from their birthdate. I made this terrible erro on a large medical records database and never lived it down.

------------------

Bruce J

Kansas City

[email protected]

[BruceJ]

Use the formula where DateOfBirthField is where the user entered date of birth.

Truncate((Status(CurrentDate)-DateOfBirthField)/365, 0)

------------------

Bruce J

Kansas City

[email protected]