Ttdfjt

I have the total number of orders placed by the customer. Now i want to get the orders between the particular range of time,like i want to get all the orders placed in last year. I am adding the code i used for getting total no of order

$_customerCollection = Mage::getModel('customer/customer')
 ->getCollection()->addAttributeToSelect('*');

foreach($_customerCollection as $customer)

 $customerTotals = Mage::getResourceModel('sales/sale_collection')
 ->setCustomerFilter($customer)
 ->load()
 ->getTotals();

 $customerNumberOfOrders = $customerTotals->getNumOrders();

Use the filter to the collection to get records between dates.

Try with below way.

$date = (new DateTime());
$_customerCollection = Mage::getModel('customer/customer')
 ->getCollection()->addAttributeToSelect('*');

foreach($_customerCollection as $customer)

 $customerTotals = Mage::getResourceModel('sales/sale_collection')
 ->setCustomerFilter($customer)
 ->addFilter('created_at', $date->format('Y-m-d 00:00:00'), 'gteq')
 ->addFilter('created_at', $date->format('Y-m-d 23:59:59'), 'lteq')
 ->load()
 ->getTotals();

 $customerNumberOfOrders = $customerTotals->getNumOrders();

Note : Above code is not tested I just share logic you have to change as per your requirement.

I hope it helps!

I resolved the problem by using this:

$fromDate = date('2016-01-01 00:00:00', strtotime($fromDate));
$toDate = date('2016-12-31 23:59:59', strtotime($toDate));


$_customerCollection = Mage::getModel('customer/customer')
 ->getCollection()->addAttributeToSelect('*');

foreach($_customerCollection as $customer)


$customerOrders = Mage::getResourceModel('sales/sale_collection')
->setCustomerFilter($customer)
->addFieldToFilter('created_at', array('from'=>$fromDate, 'to'=>$toDate))
->load()
->getTotals();

$customerCheckoutFrequency = $customerOrders->getNumOrders();

Try this code, It will help you

$_customerCollection = Mage::getModel('customer/customer')
 ->getCollection()->addAttributeToSelect('entity_id');

foreach($_customerCollection as $customer)

 $customerTotals = Mage::getModel('sales/order')->getCollection()
 ->addAttributeToFilter('customer_id',$customer->getId());
 $fromDate = date('2018-01-01 00:00:00');
 $toDate = date('2018-12-31 23:59:59');
 $customerTotals->addFieldToFilter('created_at', array(
 'from' => $fromDate,
 'to' => $toDate,
 'date' => true,
 ))->load();
 echo $customerNumberOfOrders = count($customerTotals);

Let me know,If it help you..