[Backport 2.x] Apply the date histogram rewrite optimization to range aggregation

[Backport 2.x] Apply the date histogram rewrite optimization to range aggregation #8917