November 6, 200124 yr While using FileMaker 4, the following age calculation worked: Year(Meeting Date) - Year(Date of Birth) - If(Meeting Date < Date(Month(Date of Birth), Day(Date of Birth), Year(Meeting Date)), 1, 0). In FileMaker 5.5 the same calculation is only calculating by the year, so if I use a Meeting Date of 11/7/2001, and the Date of Birth is AFTER the Meeting Date, such as 12/14/1986, the age is coming up as 15 instead of 14. Any suggestions? Becky
November 30, 200124 yr Hi Becky, I tested your calc exactly as written in FileMaker 5.5, and it worked fine. Are you still experiencing the problem? Good luck
Create an account or sign in to comment