Hi everyone,

I am looking to auto-enter a value according to a customer date of birth and gender.

I want to be able to calculate a discount percentage

For example if the customer is over 18 years old then the discount is 5% if over 65 it would be 25%.

But it should also calculate the months and days. If the baby is only 6 days old then the discount is 90% and if 8 month 80%.

Then I would also be able to give a different discount if the person is a boy or a girl. If 12 years old and girl its 10% and if boy 9%,

The % will never change so I can set up a calculation but I am not sure how to start.

Looking forward to your advises,

First you need to calculate the age, e.g.:

Calculate the Age of a Person in Years, Months and Days | FileMaker

Next you'd use a Case function, e.g.:

Case(

ageYrs > 65 ; .25 ;

ageYrs > 18 ; .05 ;

ageMonths = 8 ; .8 ;

ageDays <= 6 ; .9

)