title: SQL Retrieve data from First day of the month a year ago to today
body: <p>I understand that you can already get info from the last year using  <code>DATEADD(year,-1,GETDATE())</code> but I want to search from the first day of that month a year ago. So, for example, today is 10/17/2016. I want to search from November 1st from 2015. How would I format that?</p>