Hello!
We have had an email appeal promoted to accounts with a 2011 Created date, but the correct 15/16 appeal etc. Is there a way to correct this within Tessitura? (other than deleting and promoting with new source codes)
If I have to get into SQL server to change the date in T_PROMOTION am I likely to mess anything up? I once tried to move a source code between appeals and it had more repercussions than I was expecting.
Any advice would be appreciated!
Ann
Well, you could run an update statement in SQL server like so.
use impresariodeclare @source_no int, @new_promote_dt datetimeselect @source_no = [your source_no], @new_promote_dt = '[your revised promote date]'update dbo.T_PROMOTION set promote_dt = @new_promote_dt where source_no = @source_no
We have updated promotion dates several times over the years with no repercussions (at least that we know of!)
Updating the appeal is a trickier business like you pointed out.
Thanks Matthew! I will try your suggestion out.