• Replies 2 replies
  • Subscribers 332 subscribers
  • Views 95 views
  • Users 0 members are here
Related

Is there a way to change the promotion date?

Taylor Abbe
$organization

Hi! I recently created an extraction to add our membership renewal emails to our constituents' records, not realizing that if I didn't save the extraction it would use the old extraction date. Does anyone know of any way to update a "posted" promotion with a new date? Is there a utility that I can run to update the dates I accidentally posted? Thanks for your help!

Parents
  • Former Member
    Former Member $organization

    You can update it using SQL, not through the application itself. Your system admin should be able to help you. We've had to do this a couple times too, here's our sample code. 

    Ann

    Select * from T_promotion
    where source_no IN (24040,24039) AND promote_dt = '2109/01/11'

    Update T_promotion
    Set promote_dt = '2019/01/11'
    where source_no IN (24040,24039) AND promote_dt = '2109/01/11'

Reply
  • Former Member
    Former Member $organization

    You can update it using SQL, not through the application itself. Your system admin should be able to help you. We've had to do this a couple times too, here's our sample code. 

    Ann

    Select * from T_promotion
    where source_no IN (24040,24039) AND promote_dt = '2109/01/11'

    Update T_promotion
    Set promote_dt = '2019/01/11'
    where source_no IN (24040,24039) AND promote_dt = '2109/01/11'

Children