title: AS400 YYYYMMDD - 1 month
body: <p>We get data from one of our partners that is running an i5 AS/400 database.<br>
  Their date columns are all in YYYYMMDD format. In my query, I want to get only stuff added in the last month.</p>
  
  <p>I know I can get the current_date and subtract 1 month, but it comes in date format.<br>
  So my choices are to either take the YYYYMMDD and convert it to date format, or take the current date and change it to YYYYMMDD format.</p>
  
  <p>Since the AS/400 is missing out on the convert command that tsql has, I'm not sure which the best way to go is.</p>