⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github (I've searched it).
• I agree to follow Monica's Code of Conduct.

Bug description

reminder_outbox planned_date is in the past

Steps to reproduce

1. Running in docker, not sure if important
2. Account settings, Timezone is UTC+2 Europe/Vienna
3. Account settings, Time of the day reminders will be sent is 12 AM (must be less then the Timezone Offest from UTC)
4. Have a Contact with a birthday reminder. planned_date will be e.g. '2024-09-05'
5. Reminder gets triggered and the E-Mail sent on UTC 2024-09-04 22:00 (= midnight in UTC+2)
6. The next planned date is calculated, but instead of getting a year from now, it will be still '2024-09-05'

For some reason the calculation in

Expected behavior

Should creacte a reminder on 2025-09-05

Environment

app.monicahq.com (monica v4)

Version of Monica

4.1.2

Installation method

Docker image

Web server

Apache

Database engine version

MySQL

Additional info

If Time of the day reminders will be sent is larger than the timezone offset, e.g. if it's 3 AM, then the next planned_date is calculated correctly.