This could be customized to activate the product based on products_date_available similar to how the specials and featured products enable and disable themselves ...
This is not currently built into Zen Cart at this time ...
You would need to be careful that the auto products_status is "aware" of the stock, when the product is marked out of stock intentionally etc. ...



