Within a view listing, how can I denote whether a node's date is upcoming, current or past? I am working on an art gallery site in which we have two views that are filtered based on the date range of an exhibition. One view filters current exhibits (now >= start date &amp;&amp; now &lt;= end date) and another that filters upcoming exhibitions (now &lt; start date).

We would like to combine these into a single page view. This is simple enough to do with this date filter: now &lt;= end date. However, I would still like to denote which events are upcoming (be it a CSS class or by rendering the date field as "Opens on Dec. 12th").

Is there a way to render/rewrite the date field differently based on the field's value relative to today's date?

For example, if today's date is Nov. 1, 2015, I would like these two nodes:


Exhibit #1 (Oct. 1, 2015 - Dec. 1, 2015)
Exhibit #2 (Jan. 1, 2016 - Feb. 1, 2016)


To render like this:


Exhibit #1, Ends Dec. 1 2015
Exhibit #2, Opens Jan 1, 2016
A possible solution is to use the Views feature "rewrite result" (as explained also in Rewriting view fields), combined with the Views PHP module.

If you're not experienced in PHP, you may want to experiment with only the "rewrite result" feature, which may help to come up with an acceptable compromise for what you're looking for.;

Note: The Views PHP module only has an alfa version as of today, but it's used in about 70K sites anyway ... That many sites can't be wrong, right?