1 Reply Latest reply on Feb 25, 2011 10:38 AM by philmodjunk

    Age as of jan 1st 2011

    sly_1

      Title

      Age as of jan 1st 2011

      Post

      I have a D.O.B field.

      I need to know how i would calculate or a formula to find out.

      they was born june 17th 2001

      how old would they be as of jan 1st 2011

      hope i somewhat explained this so anyone can understand.

      Thanks 

      Sly

        • 1. Re: Age as of jan 1st 2011
          philmodjunk

          I use this calculation:

          Let ( [
                   Today = Get (CurrentDate) ;
                   bDay = Date ( Month ( Birthdate ) ; Day ( Birthdate ) ; Year ( Today ) )
                  ] ;
                  Year ( Today ) - Year ( Birthdate ) - ( Today < bDay )
                )

          This must be an unstored calculation or it will not update correctly as time passes.