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..