4 Replies Latest reply on Dec 20, 2009 4:37 PM by HugoLidia

    Age calculation not updating

    Dasher

      Title

      Age calculation not updating

      Post

      I'm using Filemaker Pro 9.0. I have two fields, Date of Birth and Age. Date of Birth is a Date type and Age is a Calculation type set to return a number. This is what I have to calculate the age.

       

      <!--  StartFragment  -->

      Let ([

      now =Get ( CurrentDate ) ;

      thisBD= Date ( Month ( Date of Birth ) ; Day ( Date of Birth ) ; Year ( now ) ) ;

      passed= now < thisBD

      ] ;

      Year (now ) - Year ( Date of Birth ) - passed

      )

      <!--  EndFragment  -->

       

      I got this from a forum I don't remember. The age does not update when the current date changes. I have to update the drop down calendar (select it and then press enter) from the Date of Birth field to calculate the current age. Any thoughts on what's wrong. Also, I don't know what "thisBD" represents.