title: How to add a certain number of days based on field value
body: <p>I'm working on creating a view to convert some values that we get coming in for dates/times. (I've figured out the times already.) In this table, dates come in the format of &quot;Days after 12-31-1840.&quot; I'm trying to create a view that shows the actual dates/times rather than in this format. This is what I have so far:</p>
  <pre><code>CASE WHEN UPPER(FLWSHT_MEAS_NM) LIKE '%DATE' THEN TO_CHAR(DATE '1840-12-31' + INTERVAL ACUTE_MEASURE_VALUE DAY)
  </code></pre>
  <p>I know that this is the correct syntax for adding dates, because I'm able to get the view working with this instead:</p>
  <pre><code>CASE WHEN UPPER(FLWSHT_MEAS_NM) LIKE '%DATE' THEN TO_CHAR(DATE '1840-12-31' + INTERVAL '30' DAY)
  </code></pre>
  <p>My question is, how do I add a specific number of days based on the ACUTE_MEASURE_VALUE field? I'm not able to run the code to get a runtime error as it's coming up as a syntax error.</p>