AnsweredAssumed Answered

Calculating a date with a future age

Question asked by Pebbles on Mar 24, 2010
Latest reply on Mar 26, 2010 by Pebbles

Title

Calculating a date with a future age

Post

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. 

 

Thank you

Outcomes