In a scenario where a hosts system locale changed to an incorrect future date and time (for example in 2017 the date and time was changed to 2018) you can remove these unwanted events by doing the following:
1. Log into mysql and use the Archive Manager ddmdb:
Windows ./mysql uroot proot ddmdb;
Linux ./mysql --defaults-file=../my-spectrum.cnf -uroot –proot ddmdb;
2. Delete the events from 2018 using mysql query:
Delete from event where time > ‘2018-01-01 00:00:00’;
Note: you can modify the year and date as required. Also take care that the year and date are set correctly or you may lose current events.