Help with Date Filter

Hi All,

I'm trying to put a filter in my report that goes from the beginning of our fiscal year to the end of the previous month.  I currently have this, but I'm getting a syntax error near the AND and I'm not sure how to fix it.

Opportunity."Close Date" BETWEEN date '2014-07-01' AND (YEAR(Opportunity."Close Date") = YEAR(TIMESTAMPADD(SQL_TSI_MONTH, -1, CURRENT_DATE)) AND MONTH(Opportunity."Close Date") = MONTH(TIMESTAMPADD(SQL_TSI_MONTH, -1, CURRENT_DATE)))

Basically, I need the fiscal year to the end of the most recently closed month, so when I run it in August, I get from July 1 to July 31 and when I run it in Sept, I get from July 1 to August 31, etc.