Get product collection filter by from and to date in magento2.

Question

I want to get product collection filter by From date and to date. How can I get this?

I have used below code in my phtml file so I get all product collection.

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();

$productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory');

$collection = $productCollection->create()
        ->addAttributeToSelect('*')
        ->load();

foreach ($collection as $product){
//echo 'Name  =  '.$product->getName().'<br>';
}

Right now I have used addAttributeToSelect('*') so I am getting all product collection but I want to filter these collection by from date and to date.

How can I get that?

Answer 1

Inject class \Magento\Framework\Stdlib\DateTime\DateTime $stdlibDateTime
For example your collection have field from_date and to_date

    // init current time now
    $currentTime = $this->stdlibDateTime->date();

    // Filter datetime
    $collections = $this->getResourceCollection()
        ->addFieldToFilter('from_date', ['lteq' => $currentTime])
        ->addFieldToFilter('to_date', ['gteq' => $currentTime])
        ->setOrder('sort_order', 'ASC')
        ->getData();

Answer 2

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();

$productCollection = $objectManager->create('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory');

$startDate = date("Y-m-d h:i:s",strtotime('2023-09-1')); // start range
 $endDate = date("Y-m-d h:i:s", strtotime('2023-10-1')); // end range

$collection = $productCollection->create()->addAttributeToSelect('*')
 ->addAttributeToFilter('from_date', array('gteq',$startDate)); //Date attribute filter
 ->addAttributeToFilter('to_date', array('lteq',$endDate)); //Date attribute filter

if($collection->getSize() > 0){
    foreach ($collection as $product){
        //enter code here
    }
}