Quote Originally Posted by Marcel Wiegers View Post
Hi!

Thanks, i figured out all the dates are on 2013-10-31, i duplicated the products one by one because of the options and so it happened that all the dates are on that day. I added new products as a test with the date of today and that didn't work because the date filed remains empty, but when i set the date to tomorrow the system configures it well (?).

The SQL query didn't work unfortunately, is it because of the 2013-10-31?

Despite of the troubles thanks for your help anyway!
I am unfortunately at a loss of what to say. I think there is a miscommunication/misunderstanding. I have more questions than answers: why is there a date in the future? What field has the future date? What is it that you are trying to display that has not been displaying unless the date is in the future? A few comments back, said that
Tthe date of the product wasn't saved properly and remained empty, that's why the categories weren't filled.
Please clarify to help with a way to rapidly get your products online/proper instead of manually adjusting 600+ items.
The SQL was "designed" based off of the description of what was provided, if that was misunderstood by me, then that is why the SQL "didn't work".

If you are showing "upcoming products" then yes, the date of concern/to be filtered must be in the future, not today and not yesterday. If we are talking about products in the respective category/(ies), I would expect that the date of concern should be in the past, because it makes sense not to show a product until a certain date/time has been reached.

Hopefully though you have figured out how to keep your products up and visible. Concerned that you will have to routinely update the database from day to day to keep your product(s) visible. There is no reason to need this and is counterproductive to running a sales site such as with ZenCart.