title: How to add one month to month and year
body: <p>I am working in oracle and new to coding and new to this site so I apologize in advance for the newbie question:</p>
  
  <p>I have a script I am trying to run that will return the sum of next months' sales orders and compare that figure against our budgeted sales forecast. It was working great last month (November) when I set it up but now that it's December, I believe it's having problems figuring out that next month is a new year. </p>
  
  <p>Essentially I  just want to sum of our sales order records from the next month and compare that number against our forecast number.</p>
  
  <p>Here is what I have so far (I'm sure I am making lots of grammatical mistakes so please be patient!)</p>
  
  <pre><code>select
     "Backlog", "Forecast Amount" , round("Backlog"/"Forecast Amount",4) as "Backlog Percent"
  
  from
      (select round(sum(NVL(unit_price,0) *NVL( ship_quan,0)),2) as "Backlog"
  
      from v_backlog_releases
  
  where
      (TO_CHAR(V_BACKLOG_RELEASES.PROMISE_DATE,'MM\YYYY') = TO_CHAR(sysdate,'MM\YYYY')+1)),
  
      (select budamount as "Forecast Amount"
  
      from
         glbudget,
         glperiods
  
        where
          glbudget.glperiods_id=glperiods.id and
          TO_CHAR(GLPERIODS.START_DATE,'MM') = TO_CHAR(sysdate,'MM')+1)
  </code></pre>
  
  <p>The system won't let me post images of the output since I am too new. Essentially I should get something that looks like this:</p>
  
  <p>Backlog | Forecast Amount | Backlog Percent</p>
  
  <p>100,000 | 200,000         | .50</p>
  
  <p>The backlog column is just a sum of ship quantities * price for all orders due to ship the following month.</p>