• Replies 3 replies
  • Subscribers 338 subscribers
  • Views 66 views
  • Users 0 members are here
Related

Changing the Promotion Created Date

Former Member
Former Member $organization

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

Parents
  • $organization

    Well, you could run an update statement in SQL server like so.

    use impresario

    declare @source_no int, @new_promote_dt datetime

    select @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

Reply
  • $organization

    Well, you could run an update statement in SQL server like so.

    use impresario

    declare @source_no int, @new_promote_dt datetime

    select @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

Children