How can I change the expiration date on a voucher?
Expired Vouchers
Jan 23, 2009
3 Replies
Backup your database before you ever do any SQL data manipulation. I believe you can only change this in the Voucher table.
UPDATE Voucher SET ExpirationDate WHERE Number Dane
I wrote the following query:
UPDATE Voucher SET ExpirationDate = '12/31/2009' WHERE Number = 322
but it didn't work. I also tried '2009-12-31' to no avail.
Any other suggestions?
That is odd. Are you sure you have the right numbers? Have you tried adding single quotes around the values? Do you have access to make changes to the DB?
Example: UPDATE Voucher SET ExpirationDate = '12/31/2009' WHERE Number = '322'
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required