channel entries starting next at the month

Question

I want to get all the channel entries for next next six months starting at the next month. I can use the month_limit and set it to 6 and I can use the start_on parameter to specify what date to start on but how do I get the 1st of the next month into that parameter? So today being April 1st I want the start_on parameter to have 5/1/2015 00:00, how to do I get that into the start_on parameter?

Answer 1

I would use an addon like this:

http://www.solspace.com/docs/date_field_filter/usage/

and you could throw on PHP parsing on that template and set a future date var:

<?php
$enddate = new DateTime();
$enddate->modify("+6 month");
?>

and your channel:entries tag would look something like this:

{exp:channel:entries
    date_field="entry_date"
    date_field_start="{current_time format='%m/%d/%Y %h:%i'}"
    date_field_stop="<?php echo $enddate->format("m/d/Y h:i"); ?>"
}

You can mess with PHP DateTime to get the 0 hour of the current date I believe, do some reading at the docs:

http://php.net/manual/en/class.datetime.php