title: No matching signature for function DATE for argument types
body: <p>There is a data column in my dataset called &quot;date&quot;. The values look like this:</p>
  <p>&quot;2022-07-23 04:16:51 UTC&quot;</p>
  <p>I am trying to select rows from my table like this:</p>
  <pre><code>SELECT
      date
      type,
      mid,
      wikipediaUrl,
      numMentions,
      avgSalience
  FROM
      myTable,
      UNNEST(entities) 
  WHERE type = &quot;LOCATION&quot; AND score &lt; -0.1 AND (date BETWEEN DATE(current_date(), INTERVAL 40 DAY) AND current_date())
  </code></pre>
  <p>However, I get an error on the between function:</p>
  <pre><code>No matching signature for function DATE for argument types: DATE, INTERVAL. Supported signatures: DATE(TIMESTAMP, [STRING]); DATE(DATETIME); DATE(INT64, INT64, INT64); DATE(DATE); DATE(STRING) at [16:60]
  </code></pre>
  <p>What am I doing wrong?</p>