http://www.magentocommerce.com/bug-tracking/ en MagentoCommerce Copyright {gmt_date format="%Y"} {gmt_date format="%Y-%m-%dT%H:%i:%s%Q"} http://www.magentocommerce.com/bug-tracking/issue?issue=3510 Posted: 2008-10-01 07:46:00
Category: Content Management System (CMS)
Version: 1.1.6
Priority: normal
Status: closed
Reported By: kalle

hello,

Product attribute: Set Product as New from Date.

Wrong logic it must be from ">=" to Date for example if the from date is 10/01/2008... it doesn't work ....

best regards
jan

---

]]> #1 / Comment by James Leckie

Also experiencing issues with the new products. However I am finding that they are not being removed when it reaches the 'to' date. Below is the offending code, however that Zend_DB_Expr stuff is black magic.

$products = $product->setStoreId($storeId)->getCollection()
->addAttributeToFilter('news_from_date', array('date'=>true, 'to'=> $todayDate))
->addAttributeToFilter(array(array('attribute'=>'news_to_date', 'date'=>true, 'from'=>$todayDate),
array('attribute'=>'news_to_date', 'is' => new Zend_Db_Expr('null'))),'','left')
->addAttributeToSort('news_from_date','desc')
->addAttributeToSelect(array('name', 'price', 'small_image'), 'inner')
->addAttributeToSelect(array('special_price', 'special_from_date', 'special_to_date'), 'left')
->addAttributeToSelect('status')
;]]> #2 / Comment by Magento Team

@kalle
We did not find this problem. Make sure you have specified date "from" (date "to" is optional).
Please try to check the timezone (all dates are stored in UTC)

@James Leckie
Thanks for report, we resolved the problem with date "to"]]> #3 / Comment by Oldgamer

Guys, I try to figure it out, cause I have same problem as James Leckie, but probably I just don't understand that logic. I assume that New Date From is earlier than New Date To, and product will be selected as new if current date is earlier than New Date To.
Can somebody give some light with this? It should be easy.

Thanks for any help.]]>