We need a field that calculates the tenure of a member from their joining date. This is crucial for competitions where members are grouped based on their tenure. You can check through this calculator : https://yashesaplama.com.tr/ (e.g., 5 years and above).

This field should support queries such as "Tenure > n years".

Additionally, we require an enhancement to determine the member's tenure on a specific date. This is necessary for events where we need to know the member's tenure as of a closing date for entries.