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

    Age calculation not updating



      Age calculation not updating


      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.