I need a Cognito Forms field that is a year. A person filling out the form enters the year when he/she joined the organization. I need to validate this field by comparing it to the person's birthdate and ensure that the person joined after age 15. I also need to use it to validate that the number of years that person has been a member of a specific chapter of this organization is not more than the total number of years that person was a member of the organization.
The year field can't be a number field because that displays the thousands separator. It can't be a text box because then it can't be used in numeric calculations.
What do you suggest?