Listings pages by date showing under wrong month

[Tyssen]

I have three events all in October and I want my events page to list events under the month of their date field. But with the below code I get two under September and one under October.

The date field values for the three events is:

• 2018-10-13 00:00:00
• 2018-10-20 00:00:00
• 2018-10-27 00:00:00

What am I doing wrong?

function childrenInMonth($page, $month, $field = 'event_date') {
  $startTime = $month;
  $endTime = strtotime("next month", $startTime);
  return $page->children("$field>=$startTime, $field<$endTime, sort=$field");
}

$events = '';

$start = $month = strtotime('today');
$end = strtotime('+1 year');

while($month < $end) :

  $event_pages = childrenInMonth($page, $month);

  if(count($event_pages)>0) :

    $events .='<h2>'. date('F', $month).'</h2>
    <ul>';

    foreach ($event_pages as $event) :

      $events .= '
        <li>
            <h3>'.$event->title.'</h3>
        </li>
      ';

    endforeach;

    $events .= '</ul>';

  endif;

  $month = strtotime("+1 month", $month);

endwhile;

 

[LostKobrakai]

You probably need to define your $month variable more thoroughly. Currently you query everything based of of month long sections around „today“, which does not align with where month start/end.

[Tyssen]

Right, changing it to $month = date('m') seems to have fixed it.

[psy]

This works for me... clinics (events) are listed under a Month Year heading.

$clinics = $pages->find('template=event, start_date>=today, limit=6, sort=start_date');
if (!$clinics->count) return;

$datetime = wire('datetime');
foreach ($clinics as $clinic) :
            $currentDate = $datetime->date('F Y', $clinic->start_date);
            if ($clinic->id == $clinics->first->id) : // first clinic?>
                <h3 ><?=$currentDate?></h3>
            <?php else :
            $prevDate = $datetime->date('F Y', $clinic->prev->start_date);
            if ( $prevDate !== $currentDate) : // different month and year ?>
                <h3 ><?=$currentDate?></h3>
            <?php endif;
            endif; ?>
            <div class="event-summary clearfix">
            <?php // event details here ?>
            </div>
        <?php endforeach; ?>