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

it should turn to 30 tomorrow

The formula you are using takes into account only the year - therefore it will change only on January 1. If you want a more accurate calculation, use =

Let ( [

today = Get (CurrentDate)

] ;

Year ( today ) - Year ( DateOfBirth ) - ( today < Date ( Month ( DateOfBirth ) ; Day ( DateOfBirth ) ; Year ( today ) ) )

)

---

P.S. Make sure the calculation field is unstored.

thx,, finally, I find out it is a " unstored" problem...

My dad and I made this calc. It is accurate to the day.

Let ( X = DateOfBirth ; Let ( y = Get ( CurrentDate ) ;

If ( Month ( y ) = Month ( X ) ; If ( Day ( y ) ≥ Day ( X ) ; Year ( y ) - Year ( X ) ; Year ( y ) - Year ( X ) - 1 )

; If ( Month ( y ) > Month ( X ) ; Year ( y ) - Year ( X ) ; Year ( y ) - Year ( X ) - 1 ) ) )

)

Hope this helps!