Age calculation

[schooltechie]

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

[Vaughan]

Are your dates entered with 4-digit years? (just a guess)

[schooltechie]

Yes, they are.

[LeCates]

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