<?
$endDate->setTime(23, 59, 59);
$startDate = (clone $endDate)->modify('-10 days')->setTime(0, 0, 0);

    function filterPaymentDatePeriod(QueryBuilder $qb, \DateTime $startDate, \DateTime $endDate)
    {
        $qb->andWhere('AccountTransaction.paymentDate 
        BETWEEN :AccountTransactionStartPaymentDate AND :AccountTransactionEndPaymentDate')
            ->setParameter('AccountTransactionStartPaymentDate', $startDate)
            ->setParameter('AccountTransactionEndPaymentDate', $endDate);
        return $this;
    }
    ?>