<div>
the LAST_DAY() did the trick. thx!
</div>


<div>
<div class="content wysiwyg-content">
I am trying to report numbers back rolled up by <b>month </b>for the past 6 months based off of the current_date() field. &nbsp;I tried using date_add(month(current_dat<wbr />e()),INTER<wbr />VAL -6 MONTH) but that does not work. &nbsp;<br />
<br />
I did have date_add(current_date(),IN<wbr />TERVAL -6 MONTH) in place but that is not totally accurate because if i run the query in the second week of the month then the first month (october) will only have numbers for the remaining two weeks. &nbsp;I need it by month.
</div>
</div>


I am trying to report numbers back rolled up by month for the past 6 months based off of the current_date() field.  I tried using date_add(month(current_date()),INTERVAL -6 MONTH) but that does not work.  

I did have date_add(current_date(),INTERVAL -6 MONTH) in place but that is not totally accurate because if i run the query in the second week of the month then the first month (october) will only have numbers for the remaining two weeks.  I need it by month.

current month with rolling previous 6 months in mysql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.