mirror of
https://github.com/actualbudget/actual.git
synced 2026-03-09 11:42:54 -05:00
[Bug]: "Last 3 months" custom reports clickable links have off-by-one error? #2443
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#2443
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @jonner on GitHub (Sep 3, 2025).
Verified issue does not already exist?
What happened?
I created a custom report to generate a summary of all of my expenses from the last 3 months.
I used "Data table" mode with the following settings:
In the data table, it shows a list of all categories with headers "Deposits", "Payments", "Total", and "Average". The amounts in the first three columns are clickable, and when clicked, they bring you to a ledger that lists all of the transactions from that category within the given time frame.
It is currently September 3, so I expect the table to show a summary of transactions from June, July, and August. But when I click on a value in the "Total" column for a category, I get the following:
In other words, the ledger shows all transactions between May 1 and August 31. So there seems to be an off-by-one error here somewhere. It looks like the actual values in the table don't include the transactions from May, so perhaps only the links are incorrect.
Actually, it looks like the links are incorrect on the other end as well, since the (few) transactions in my accounts from September are included in the data table summary, but the ledger only shows a filtered list of transactions through the end of August.
How can we reproduce the issue?
Create a custom report with the settings mentioned above, and click the links in the 'total' column.
Where are you hosting Actual?
Docker
What browsers are you seeing the problem on?
Firefox
Operating System
Linux
@youngcw commented on GitHub (Sep 4, 2025):
Does it do this in all browsers? Does this happen in the demo?
@jonner commented on GitHub (Sep 4, 2025):
Oh, interesting. I just checked and I couldn't reproduce the wrong date range on the demo server (it showed transactions between 6/01/2025 and 9/30/2025 rather than between 5/01/2025 and 8/31/2025), and then I noticed that after I updated my local server to the new 25.9.0 release, it doesn't seem to have the date issue here anymore either. So maybe it got fixed in the latest release?
@youngcw commented on GitHub (Sep 4, 2025):
I don't know. The date library like to play games sometimes and adjust things because of time zones. Ill close for now