Need a *working* script to find a consumer's age

[zenboy32]

I've tried different suggestions. They either didn't work or I didn't fully understand the instructions. Given a birthdate, I want to find the consumer's age in years-just years.

[markpro]

have you tried a calculated field based on a DOB field.

Int((Status(CurrentDate)-DOB)/365)

Int refers to the integer value, or whole number portion of the calculation, DOB being the Date of Birth field in your database.

Hope this helps.

[DLS]

Here you go:

Create an Auto Enter by Calculation field and use this calculation:

You need a DOB Date Field for this to work.

NumToText(Year(Today) - Year(DOB) - If(Today< Date(Month(DOB), Day(DOB), Year(Today)), 1, 0))

This will give you the correct age in years to the day.

[Vaughan]

Use Status(CurrentDate) and Status(CurrentTime) instead of the Today function. Today is only calculated when the application first starts up, so it may be incorrect if the program is running for more than 24 hours.

yeah, it's a bummer... but that's why they made the Status functions.