if then formula for text input

if then formula for text input

I have a members table in DB. One field in that table is Date of Birth. I would like to have another field that shows a level of membership available based on a calculation using the date of birth and today's date.

For example: A person born before 31/12/2991 should return a value of "Cadet/te". If someone is born later it would return "Junior".

How would I do that?

Dave