title: Big Query (SQL) Add one month to the date (Issue) - (Data Studio)
body: <p>Currently, I'm adding an extra month this way:</p>
  
  <pre><code>DATE_ADD(date, INTERVAL 1 MONTH) AS pDate
  </code></pre>
  
  <p>I'm trying to compare two values by month, by using the same date range. So I made another custom field with date +1 month and when I use it...it missing days with 31.</p>
  
  <p>June 30 +1 month = July 31 and as I using custom field... it missing fields where date with 31</p>
  
  <p><strong>EDITING  v1.0</strong></p>
  
  <p>I have a database for a year, each day is presented. </p>
  
  <p>As example:</p>
  
  <pre><code>01012018
  ....
  31012018
  01022018
  ...
  28022018
  </code></pre>
  
  <p>I need to compare two time period and to solve this issue I create a custom field which takes the date and add +1 month, so after in Data studio (could be in any over platform) can compare 25-30January with 25-30February, the issue is when I add 1 month to the date 30012018 it becomes 30022018 (WHich as you know does not exist)</p>
  
  <p>Anyway, I'm sticking with this idea, but maybe there are any other ways of doing this? WIll repeat again, I need to compare the same date but from different month - 15th January -20 January WITH 15th February - 20th February, but again issue where 30th-31st appears</p>