Magento 2: Get orders between a Specific Date Range

I need to get order collection between specific date range passing start date and end date in Magento 2. For that I used filter created_at field using addAttributeToFilter().

First create Block file By default created_at field in sales_order table represent the time of order creation:

<?php
namespace Vender\Modulename\Block;
class OrderRange extends \Magento\Framework\View\Element\Template
{
 public function __construct(
 \Magento\Framework\View\Element\Template\Context $context,
 \Magento\Sales\Model\ResourceModel\Order\CollectionFactory $orderCollectionFactory,
 array $data = []
 ) {
 $this->orderCollectionFactory = $orderCollectionFactory;
 parent::__construct($context, $data);
 }

 /* Here Create Function For Order collection between start and end date */
 public function getOrderCollectionByDateRange(){
 $startDate = date("Y-m-d h:i:s",strtotime('0000-00-00')); // start date
 $endDate = date("Y-m-d h:i:s", strtotime('0000-00-00')); // end date

 $orders = $this->orderCollectionFactory->create()
 ->addAttributeToFilter('created_at', array('from'=>$startDate, 'to'=>$endDate));
 return $orders;
 }
?>

<?php

namespace Vender\Modulename\Block;

class OrderRange extends \Magento\Framework\View\Element\Template

{

public function __construct(

\Magento\Framework\View\Element\Template\Context $context,

\Magento\Sales\Model\ResourceModel\Order\CollectionFactory $orderCollectionFactory,

array $data = []

) {

$this->orderCollectionFactory = $orderCollectionFactory;

parent::__construct($context, $data);

}

/* Here Create Function For Order collection between start and end date */

public function getOrderCollectionByDateRange(){

$startDate = date("Y-m-d h:i:s",strtotime('0000-00-00')); // start date

$endDate = date("Y-m-d h:i:s", strtotime('0000-00-00')); // end date

$orders = $this->orderCollectionFactory->create()

->addAttributeToFilter('created_at', array('from'=>$startDate, 'to'=>$endDate));

return $orders;

}

After do this You need to call this function in any custom template file or any exsting template,

if($orders->getTotalCount() > 0) { 
 foreach($orders as $_order) {
 echo "<pre>";print_r($_order); echo "</pre>";
 }
}

if($orders->getTotalCount() > 0) {

foreach($orders as $_order) {

echo "<pre>";print_r($_order); echo "</pre>";

}

Now you can get Order collection by date range.

Fill the below form if you have any Magento programming need.

Add an image programmatically from any url in Magento 2
[crayon-63d3d92ed8e92729435547/] Using above fucntion Images can be imported directly from...
Magento 2 : Override the Category view block file
Override view block using di.xml and add the below code...
How to check list of Layout XML called for a specific page in Magento 2?
You can check a list of called layout XML for...
Magento 2 : Setup PWA from Scratch
Follow the below steps to install and set up PWA...
How to remove leading zero’s from the order, invoice and shipment number in Magento 2?
If you want to remove all leading zero's from order,...

Author Info

Magento Developer

Hire T. Baldha

Let’s have a call

Fill the form & Get Installation Support