title: Last 18 Months data from a Date field of Fact Table: In Teradata SQL Assistant
body: <p>I have a Date field with data format: 1/20/2014 05:52:05.000000</p>
  
  <p>Now I need to put a WHERE condition in such a way that I can get the last 18 Months data from the Fact table (excluding Current Month).
  For example, if I run the table in February (Date field has February data and I don't need this), I should get data from Jan 2015 and 18 month backwards. </p>
  
  <p>What would be the query for this?</p>