title: Select Last Previous month in Conditional Split Transformation Editor
body: <p>There is a column called [Month] that I am working on. The goal 
  is to dynamically select ONLY the last month (as the data comes
  in monthly, but it has old data as well).</p>
  
  <p>In the Conditional Split 
  Editor I wrote the following </p>
  
  <pre><code>MONTH([Month])=MONTH(DATE())-1 And YEAR([Month])=YEAR(DATE()),
  </code></pre>
  
  <p>but it did not work - red all through.</p>
  
  <p>Is there a better way to write this in the Conditional Split 
  Transformation Editor?</p>