CreatoX

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 ?

Hi All, I'll try to formulate my question as easy as possible. Presume I have the following events in a table: (Dateformat: DD-MM-YYYY HH:mm) 01-01-2017 12:00 Event 1 (Sunday) WEEKLY 09-01-2017 12:00 Event 2 (Monday) ONCE Let say, today is Saturday 07-01-2017. 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: 08-01-2017 12:00 Event 1 (Sunday) WEEKLY 09-01-2017 12:00 Event 2 (Monday) ONCE Is there a way to accomplish this within mysql querying ?