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,