title: BigQuery error: No matching signature for operator >=
body: <p>I am getting an error <code>No matching signature for operator &gt;= for argument types: STRING, INT64. Supported signatures: ANY &gt;= ANY at [1:60]</code> when I run this <code>R</code> script to fetch some data from <code>BiqQuery</code>.</p>
  
  <p>This is where I get the error: </p>
  
  <pre><code>a &lt;- dbGetQuery(db,
  paste0("select * from dta.tbl where col1='",
  somevariable"' and date&gt;=",substr(gsub("\\D","",as.character(start.date)),3,8),
  " and date&lt;=",substr(gsub("\\D","",as.character(end.date)),3,8)))
  </code></pre>
  
  <p>Any clue on how do I get rid of this error? I am using standardsql here</p>
  
  <p>Thanks ahead! :) </p>