Age Calculation

[Jscott]

I was wondering what the easiest way would be to create a simple script to calculate the age based on the DOB and the current date.

[LaRetta]

You haven't indicated the result you wish ... whether in years, written out in years and days or whatever. Here's one. I think I have this puppy memorized. This gives you their age in years. Calculation result should be number:

Let ( [

now = Get ( CurrentDate ) ;

b = DOBdateField

] ;

Year ( now ) - Year( b ) - (( Month ( now ) + Day ( now ) / 100 ) < ( Month ( b ) + Day ( b ) / 100))

)

Calculation must be unstored to update properly. You don't need a script but I suppose you could use it that way. I learned this from Comment or Ray - not sure which now.

LaRetta

[Jscott]

Thank you so much... I thought I was pretty good at this thing.. Just goes to show ya!

[MarkVXII]

Thank you LaRetta!

"Search and you will find"