title: Setting report column to YES or NO based on date - Oracle SQL
body: <p>I have a query that will create a report (Excel spreadsheet) and now I need to add two columns: "2017 DNR" and "2018 DNR" to the report.  There is a column in the table named DNRDATE (format dd-MON-yy) and if it is NULL, I need both columns to say "NO" in the report.  If there is a DNRDATE, need to check if that date is 2017 or 2018.  If it's 2017, then both columns get a "YES".  If it's 2018, then "2017 DNR" gets a "NO" and 2018 gets a "YES."  </p>
  
  <p>Should I use a CASE WHEN for this?  And how would that work?</p>