Fix end date filter in global time tracking report

Lee Tickettrequested to merge
499814-fix-timelog-report-date-filter into master

What does this MR do and why?

1 day is currently added to the end date but we do a <= comparison in the backend so this includes entries from 00:00:00 the follow day.

The fix is to set the time to the end of the day.

References

Fixes #499814 (closed)

Screenshots or screen recordings

Before After
image image

How to set up and validate locally

Add a few timelogs in the past using quick actions:

  • /spend 1h 2025-03-18
  • /spend 1h 2025-03-17

Check when you run the timelog report http://localhost:3000/-/timelogs for 2025-03-17 you only get the timelog from the 17th

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Merge request reports