### Title

Calculate age

### Post

I try to find out a formula to calculate UPDATE age,,, here is the formula I use right now

Year(Get(CurrentDate)) - Year(DateOfBirth)

but it will not update, for example:

DateOfBirth = 09/18/1980

Today= 09/17/2011

so,, today age is 29

it should turn to 30 tomorrow,,, but the formula wont update the age..... any solution, thank you

If someone's birthday is 9/21/1980, your calc shows them 31 when they are actually still 30 (they won't turn 31 for few more days).

I would suggest a calculation such as this which adjusts to allow for it:

Let ( [

today = Get(CurrentDate) ;

b = dob

];

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

)

Be sure to go into this calculations Options (and then Storage Options) and uncheck 'do not store calculation results' so it will update. This is probably why yours wouldn't update as well. :^)