Incorrect energy calculation for custom date ranges spanning 3 months

[Mice30]

The problem

When using the Energy dashboard in Home Assistant to calculate electricity consumption for a custom date range spanning three months (e.g., from 17.09.2024 to 19.11.2024), the results are incorrect. The system appears to include the entire month of September 2024 and November 2024 in the calculation, instead of starting / ending from the specified date (17.09.2024 -19.11.2024).

For date ranges spanning two months, calculations are accurate. However, when the range spans three months or more, the results are inflated because the system misinterprets the start and/or end of the custom date range.

September data :

What version of Home Assistant Core has the issue?

core-2024.12.5

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant OS

Integration causing the issue

Energy

Link to integration documentation on our website

No response

Diagnostics information

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

No response

Additional information

No response