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!
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_promotionwhere source_no IN (24040,24039) AND promote_dt = '2109/01/11'
Update T_promotionSet promote_dt = '2019/01/11'where source_no IN (24040,24039) AND promote_dt = '2109/01/11'
Thanks Ann!