Hi there!
My organization would like to start sending automated birthday emails using WordFly. We currently store birthdays as an attribute. In order to integrate with WordFly, I need to create a dynamic list in Tessitura using the birthday attribute criteria. I'm in the testing phase right now, and when I configure the data to equal my own birthday, I receive the following error message and I'm not sure why.
"List generation has failed.: Error 242, Severity 16, State 3, Procedure n/a, Line 1, The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."
Later I'll need to take this list one step further and configure the criteria to equal a specified month and date, but any year. Has anyone created a list like this before? How did you do it?
As Maery described, varchar birthdates will be troublesome for SQL to work with. If your data is anything like my old conversion data was re: birthdates, e.g. "Jan 10", or "1945/01/15", or a variety of other formats, all living side by side, you may have a cleanup task ahead of you.