SQL Code for Specials?

[jmberman]

Is there a SQL code I can use to set all my specials expiration date to the same date?

[lat9]

As always, back up your database first.

Then copy/paste the following into your Zen Cart admin's Tools->Install SQL Patches (after modifying the year/month/date values) ... note that the intervening dashes (-) are required:

UPDATE specials SET expires_date = 'YYYY-MM-DD';

[jmberman]

As always, back up your database first.

Then copy/paste the following into your Zen Cart admin's Tools->Install SQL Patches (after modifying the year/month/date values) ... note that the intervening dashes (-) are required:

UPDATE specials SET expires_date = 'YYYY-MM-DD';

I love you, thank you so much. Worked perfect.