Hi All,
I'll try to formulate my question as easy as possible.
Presume I have the following events in a table: (Dateformat: YYYY-MM-DD HH-mm)
2017-01-01 12-00 Event 1 (Sunday) WEEKLY
2017-01-09 12-00 Event 2 (Monday) ONCE
Let say, today is Saturday 2017-01-07.
How can I query the table to get the first oncoming event is the Weekly "Event 1" on Sunday and not get the event on Monday?
The best solution for me would be to get the 'real' next event date for the recurring events. So the output of a select statement will be:
2017-01-08 12-00 Event 1 (Sunday) WEEKLY
2017-01-09 12-00 Event 2 (Monday) ONCE
Is there a way to accomplish this within mysql querying ?