Calculating a date with a future age
Hello, I am using FM 10 on Windows XP. I am fairly new at this program but I have created a one to many relational database with multiple fields.
What I need now is to calculate a date based on a future age of a child.
For example I have a EOE date (End of Eligibility) on my parent table. I need to create a EOE date on the child's table based on when the child turns 22 yrs of age. In other words I want to calculate the future date of when the child turns 22 yrs of age based on the end of eligibility date on the parents table.
The calculation for the EOE on the parents table was simple this is what I have for that:
(three QAD + 1095) which is basically the qualifying arrival date plus 3 yr.
Any help would be appreciated.