title: GBQ previous month
body: <p>I'm trying to pull all days for previous month however my below query only pulls last month’s same day. Is this possible? Thanks for the help!</p>
  
  <pre><code>select *
  FROM
  (TABLE_DATE_RANGE([BI_UU_HH.CID_BKID_AID_Raw_],
  TIMESTAMP(DATE_ADD(CURRENT_DATE(),-1,"Month")),
  TIMESTAMP(DATE_ADD(CURRENT_DATE(),-1,"Month"))))
  </code></pre>
  
  <p>Results:
  Date
  2016-07-30</p>
  
  <p>Desired Results:
  Whole month of July</p>