AnsweredAssumed Answered

Calculate age

Question asked by joaol on Sep 18, 2011
Latest reply on Sep 19, 2011 by joaol


Calculate age


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