Sort by closest to today? I've got an show/performance relationship, where a show can have multiple performances, and each performances has a single date (when the performance takes place).

I'm showing these in a Drupal view, but it's becoming a bit problematic.

I need to sort this list so that the shows with the closest performances to now appear at the top, the problem is that shows with only past performances also need to show.

The last part appears particularly problematic, I think I could just sort this by greater than or equal to now, but I don't think that will be sufficient in this case.

Is this possible? Or do I need to try and argue for a different way of displaying this content
I would make two view lists, one to show forthcoming performances and one to show past performances.

This way you can title each list so it's clear to users which is which. It would be feasible through careful CSS to make it look like they are one list. And each list will only show as required.

Filter on the date, either '>= now' or '&lt;= now', to make each list work as you wish.