use case

something like

Code:
select
  case 
  when end_date is null 
       or end_date < trunc(sysdate)
  then 'X'
  else 'Y'
  end end_date
from table;