Expected date products - change date for all.

Hi everyone

Say you have 100 products you expect to have in december. And you you want to change the expecting date for all these 100. IS there a way to select all those products which this considers and then select a date and click update? Istead of having to do it manually 1 and 1 product.

Thanks

If the date you want to change is for December 22, 2010 ... and you want to set it to December 25, 2010 then you could use:

UPDATE products SET products_date_available = '2010-12-25' WHERE products_date_available >= '2010-12-22' and products_date_available < '2010-12-23';

Before doing this, you want to make a backup of your database first ...

Ajeh:

If the date you want to change is for December 22, 2010 ... and you want to set it to December 25, 2010 then you could use:

UPDATE products SET products_date_available = '2010-12-25' WHERE products_date_available >= '2010-12-22' and products_date_available < '2010-12-23';

> 
> Before doing this, you want to make a backup of your database first ...

Great idea. Thanks :)