jef531 Posted June 21, 2009 Share Posted June 21, 2009 I am trying to setup the catalog to exclude products that are listed on the products expected page. I have created the query listed below which works from the SQL server but I cannot seem to get it to work in the code. Any help or ideas will be appreciated. select products where products_date_available is null or to_days(products_date_available) <= to_days(now()) and ... Link to comment Share on other sites More sharing options...
jef531 Posted June 21, 2009 Author Share Posted June 21, 2009 Nevermind... I figured it out: select products where to_days(products_date_available)<= to_days(now()) or products_date_available is NULL Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.