How to Add 7 Days to Current Date in Magento 1

datelocalemagento-1

I need to save to db current date & "current date + 7days" values. For this I'm using following function. But how to add 7 days to this.

 Mage::getModel('core/date')->date('Y-m-d H:i:s');

Thanks in advance.

Update:

$res = Mage::getModel('rad_inventorypieces/reserve');
$date = new Zend_Date(Mage::getModel('core/date')->timestamp());
$res->setCreatedDate($date);
$date->addDay('7');
$res->setExpiryDate($date);

Best Answer

In OOP style:

$date = new Zend_Date(Mage::getModel('core/date')->timestamp());
$date->addDay('7');
$date->toString('YYYY-MM-dd HH:mm:ss'); //Returns representation of date

Related Solutions

Magento – Customer created_at Date off by months

The problem is in Mage_Eav_Model_Entity_Attribute_Backend_Time_Created::beforeSave. This line ends up swapping the month and day:

$zendDate = Mage::app()->getLocale()->utcDate(null, $date, true, $this->_getFormat($date));

This happens to just about all entity types including products and customers, and happens during creation and normal save events, in both CE >= 1.8.x and EE >= 1.13.x.

Override this model in your own module, and replace the beforeSave method with this:

public function beforeSave($object)
{
    $attributeCode = $this->getAttribute()->getAttributeCode();
    $date = $object->getData($attributeCode);
    if (is_null($date)) {
        if ($object->isObjectNew()) {
            $object->setData($attributeCode, Varien_Date::now());
        }
    } else {
        // ADD THIS
        $date = strtotime($date);

        // convert to UTC
        $zendDate = Mage::app()->getLocale()->utcDate(null, $date, true, $this->_getFormat($date));
        $object->setData($attributeCode, $zendDate->getIso());
    }

    return $this;
}

This also needs to be corrected on the way out of the database. Replace afterLoad with this:

public function afterLoad($object)
{
    $attributeCode = $this->getAttribute()->getAttributeCode();
    $date = $object->getData($attributeCode);

    // ADD THIS
    if (!is_null($date)) {
        $date = strtotime($date);
    }

    $zendDate = Mage::app()->getLocale()->storeDate(null, $date, true, $this->_getFormat($date));
    $object->setData($attributeCode, $zendDate->getIso());

    parent::afterLoad($object);

    return $this;
}

Edit: Here is an example of how to override this class.

<global>
    <models>
        <eav>
            <rewrite>
                <entity_attribute_backend_time_created>Mycompany_Mymodule_Model_Eav_Entity_Attribute_Backend_Time_Created</entity_attribute_backend_time_created>
            </rewrite>
        </eav>
    </models>
</global>

Then create the file app\code\local\Mycompany\Mymodule\Model\Eav\Entity\Attribute\Backend\Time\Created.php

Magento – How to add date filter to product collection

I'm not sure about your actual use case, but to filter a product collection so that it only returns products created within the last 3 days do as follows

$collection = Mage::getResourceModel('catalog/product_collection')
    ->addFieldToFilter('created_at', array('gt' => date("Y-m-d H:i:s", strtotime('-3 day'))));

Best Answer

Related Solutions

Magento – Customer created_at Date off by months

Magento – How to add date filter to product collection

Related Topic