How can I rewrite a date field "End Date" to be "present" if no value is entered? I have a date field for an item in which I am entering a range of years. I have created a view which displays the start date and end date as individual fields. Typical output looks like this:


  Title: Pop Art
  Start Date: 1958
  End Date: 1970


However, there are several items which do not have an end date because they are ongoing. Even though for the end date field's "No Results Behavior" I have "No results text" set to the word present it renders the start date in place of my rewrite text:


  Title: Contemporary Art
  Start Date: 1970
  End Date: 1970


I want it to do output like this:


  Title: Contemporary Art
  Start Date: 1970
  End Date: present


How can I get the end date to render as the word "present" when no end date is specified?

Note: in my final view I will output the date range as, "1970-present." Above, I formatted my examples as "label: value" for clarity.
When there is no end date specified for a node it takes both the dates same. The module consider it a one day event.

However, in your case you are making it ongoing by not mentioning the end_date so no results behavior is not going to work. I would suggest to use some global php like this

&lt;?php
if($row-&gt;field_date == $row-&gt;field_date_1) {
   echo "Present";
} else {
  echo $row-&gt;field_date_1;
}
?&gt;


Make sure to include this php field after both start and end date fields, and make the end date fields hidden.