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