title: Using Where Clause with Dates When Reading SQL Query in R
body: <p>I am attempting to query an Oracle datebase from R using the SQL function found <a href="https://stackoverflow.com/a/44886192/11918054">here</a>. </p>
  
  <p>When I complete an easy query, such as </p>
  
  <pre><code>'SELECT * FROM TABLE_1'
  </code></pre>
  
  <p>the query executes fine. However, when I add a conditional date statement to the query, such as</p>
  
  <pre><code>'SELECT * FROM TABLE_1 WHERE START_DT BETWEEN '01-JUL-2018' AND '30-JUN-2019'
  </code></pre>
  
  <p>I get the following error message:</p>
  
  <blockquote>
    <p>Error in .oci.SendQuery(conn, statement, data = data, prefetch =
    prefetch, : ORA-00904: "30-JUN-2019": invalid identifier</p>
  </blockquote>
  
  <p>Any idea how I can fix this?</p>