title: Snowflake - Query Last 12 Months of Data
body: <p>How would I pull the last twelve months of records without using Between? I've attempted variations of the following in my where clause :</p>
  
  <pre><code>DATEADD(YEAR,-12,O.CREATEDATE)
  </code></pre>
  
  <p>&amp;</p>
  
  <pre><code>TO_DATE(O.CREATEDATE)&gt;=DATEADD(YEAR,-12,O.CREATEDATE)
  </code></pre>
  
  <p>The <strong><em>Snowflake</em></strong> documentation on this SQL function appears to explain how the datadd simply changes the date. Is there a <strong><em>snowflake sql</em></strong> function that will execute this type of request?</p>
  
  <p>Thank you kindly</p>