use DATE on NOW() to ensure the current days event is next