title: Date function for following month
body: <p>What function can I use to get the date for the following month, in the format 201907?</p>
  
  <p>The following code snippet returns 201907, but I need a function that will always return the next month</p>
  
  <pre><code>select 
      convert(varchar(6), DATEFROMPARTS(YEAR(GETDATE()), 7, 1), 112)
  </code></pre>