1. Home
  2. Point-Of-Sale Software
  3. Expired Vouchers

Expired Vouchers

How can I change the expiration date on a voucher?

Reply to
Stitcher
Loading thread data ...

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

Reply to
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?

Reply to
Stitcher

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'

Reply to
Dane Fieber

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.