I understand that I need to compare two dates: today and the event date. I have sort of done that in the code below, but it still shows all the events.
The contents of bands.php:
What will be the best way to display only upcoming events where the date is either equal or higher than today date?
- Code: Select all
<cms:set event_date="<cms:get_custom_field 'event_date' masterpage='bands.php'/>" />
<cms:if event_date ge "<cms:date format='Y-m-d H:i:s' />" >
<cms:pages masterpage='bands.php' limit='6' orderby='weight' order='asc'>
<h3><cms:show k_page_title /> - <cms:date event_date format='jS M Y'/></h3>
<p><cms:show event_desc /></p>
</cms:pages>
<cms:else/>
<p>Check back later for new events!</p>
</cms:if>
The contents of bands.php:
- Code: Select all
<cms:template title='Bands' clonable='1' order='5' >
<cms:editable type='datetime' name='event_date' label='Event date'/>
<cms:editable type='nicedit' name='event_desc' label='Event description' />
<cms:config_list_view orderby='weight' order='asc'>
<cms:field 'k_selector_checkbox' />
<cms:field 'k_page_title' sortable='0' />
<cms:field 'event_date' header='Event date' sortable='1'>
<cms:date event_date format='jS M y' />
</cms:field>
<cms:field 'k_actions' />
</cms:config_list_view>
</cms:template>
What will be the best way to display only upcoming events where the date is either equal or higher than today date?