Filter by end date if it exists, if not then filter by start date

Question

I have a view of events, which has a start date and an end date (2 separate fields as the end date was added later). The end date is optional. I want to show events that are either in the future or are currently ongoing. So somehow I need to check if the node has an end date - and if so apply the filter on that, but if not then use the start date instead.

Is there any way to achieve this? Maybe I'm looking at in the wrong way.

Answer 1

Either you make end date field mandatory or use hook_views_query_alter to get ongoing or future events.

If you go with field mandatory option, you simply need to add two view filters with OR condition.

1. Start date >= Today OR
2. End date >=Today