Hi Victron Energy,
if I initiate a CSV download in the advanced view of VRM portal with the range of a whole month, then sart and end timestamps in the CSV/XLSX export file do not match with "From" and "To" of custom range. The curious thing is that the data presented in the diagrams corresponds to the expected result, but the export contains a slightly different data slice. Even the generated file names contain different time specifications.
I would expect to have timestamps with values greater than or equal to "From" and less than "To", but the start and end timestamps in the resulting file will vary depending on the selected month.
Some examples:
Sep 2022
From: 2022-09-01 00:00 To: 2022-10-01 00:00
Filename: XXX_kwh_20220901-0100_to_20221001-0059.csv (expected: XXX_kwh_20220901-0000_to_20220930-2359.csv)
First timestamp: 2022-09-01 01:00:00 (expected: 2022-09-01 00:00:00)
Last timestamp: 2022-10-01 00:45:00 (expected: 2022-09-30 23:45:00)
Oct 2022
From: 2022-10-01 00:00 To: 2022-11-01 00:00
Filename: XXX_kwh_20221001-0100_to_20221031-2359.csv (expected: XXX_kwh_20221001-0000_to_20221031-2359.csv)
First timestamp: 2022-10-01 01:00:00 (expected: 2022-10-01 00:00:00)
Last timestamp: 2022-10-31 23:45:00 (ok)
Nov 2022
From: 2022-11-01 00:00 To: 2022-12-01 00:00
Filename: XXX_kwh_20221101-0000_to_20221130-2359.csv (ok)
First timestamp: 2022-11-01 00:00:00 (ok)
Last timestamp: 2022-11-30 23:45:00 (ok)
Dec 2022
From: 2022-12-01 00:00 To: 2023-01-01 00:00
Filename: XXX_kwh_20221201-0000_to_20221231-2359.csv (ok)
First timestamp: 2022-11-01 00:15:00 (expected: 2022-11-01 00:00:00)
Last timestamp: 2022-12-31 23:45:00 (ok)
Can this behavior be fixed?
