AnsweredAssumed Answered

Creating a Year of Birth

Question asked by MJWebster on Dec 26, 2009
Latest reply on Dec 26, 2009 by MJWebster


Creating a Year of Birth




Just wondering if the following is possible?


I have a field in my database for the age of someone (AGE). I also have a field for Date of Enrolment (DATE ENROLLED). 


The idea here is to enter the age of someone ie 40, and then enter the date enrolled, 22 May 1902, what I wanted then was a field called Approx Year of Birth, in this field it would take 40 from 1902 = 1862... however how can I do this when the field (Date Enrolled) has the format that I set up as Day, Month and Year?


Hope this makes some sense...


Running Filemaker 10 on Apple Mac (Snow)


Thanks for any help..


Regards, Malcolm