AnsweredAssumed Answered

Creating a Year of Birth

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

Title

Creating a Year of Birth

Post

Hello, 

 

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  

Outcomes