I am trying to figure out my Patrons with a tenure of 25 years or more, but I cannot figure out what values to use when I select the "Tenure" criteria in the list manager! It won't take dates, or words, so I am a bit confused as to how to make it work!
Thank you!
Hi Danielle,
It sounds like this is a custom criteria built for your organization. I would check with your Tessitura administrator to see if they can give you some guidance. If you are trying to determine where the data for that criteria is coming from, you can right-click on the criteria in List Builder and it will tell you the Table and Column names that are providing the data for it which might give you some hints.
My guess is that the criteria has an incorrect Data Type assigned in the T_KEYWORD system table.
- Levi