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?
Is your birthday attribute set up as a datetime field? I have often seen them set up as a string, and that causes a lot of trouble when trying to do date filtering.
Where can you check for that? in System Tables or ? I think this is part of our problem. I try to get just January birthdays, for example, and I get everyones.
There's a system table called T_KEYWORD that contains all attributes and list builder criteria - you can find the Birthday attribute there and look at the 'Data Type'.