Calculated Expiry Date with multiple results

If you want to create an expiry date that changes depending on a Date of Birth to various values do the following..

1. Add a calculated field called Expiry Date

Menu Button > Modify Database > Add Field > Calculated Field > Name it 'Expiry Date'. If you have the default expiry date field in the database you will need to remove it.

2. Add this script to the default value within the Expiry Date field..

Menu Button > Modify Database > ModifyField >Click Expiry Date Field and Edit table on left in default value as below using this script..

Iif(Age(Date Of Birth) < 7,  AddYears(Date Of Birth, 7),  Iif(Age(Date Of Birth) < 18,  AddYears(Now, 5 ), AddYears(Now, 10) ) )

Click OK > Save to save changes

3. Add a field called Date Of Birth which needs to be populated with Date Of Birth data..

Menu Button > Modify Database > Add Field > Add Date Of Birth Field.

This example will do the following

If they are under 7 years old, it should expire on their 7th Birthday, if they are under 18 it should expire 5 years from printing and otherwise, it should expire 10 years from printing.