This is somewhat similar to: https://www.drupal.org/node/1635810

I have created a website for a university art museum. (http://lcva.longwood.edu)

On their home page, I have created a slideshow displaying current and soon-to-be-upcoming exhibitions, with their start and end dates, title and location. So far so good. I have successfully filtered the view by date, i.e. the exhibition start date must be <=now+2weeks and the end date must be >= now.

However, certain exhibitions are actually "ongoing" and have no fixed end date. In order for these exhibitions to show up in the display they must have an end date, so I have given them an invented end date of 12/31/2060.

The problem comes when outputting the display.

I want the "ongoing" exhibitions to show "Ongoing" instead of the start and end dates.

Is there a non-kludgy way to tell views to display the start and end dates only "if the end date is NOT equal to 12/31/2060, and in that case display "ongoing"?

I have tried several solutions but all are terribly kludgy, i.e. add an extra text field for end date in each exhibition and then use that instead of the programmatical one in views fields.

Comments

Katharine_Gates created an issue.