Showing purchases made within the previous 8 months using SQL
Posted on 2011-10-17
I am trying to find purchases made within the previous 8 months. This does not include the current month but starting 1 month before the current month up to 8 months.
I have figured out how to find the purchases made in the last 8 months (query below), but how do I exclude that current month.
WHERE purchase_date > (DATEADD(m, -6, GETDATE()))