Thread

I’m using Solspace Calendar for the events section of my website and Geofinder to allow users to search for events near them.

I’ve come a bit stuck when I want to display upcoming Calendar events within the Geofinder results.

All I need to do is ensure the results page only shows upcoming events and not past events. As Calendar doesn’t use the entry_date I’m not sure the best way to go about this.

I’ve looked at the database table and there is a ‘start_date’ field in ‘exp_calendar_events’, but I don’t know how to use this within the Geofinder tags.

I should add I’m not experienced with the query module yet.

because you’re using the geofinder module to do the searching, the geofinder module would need to support the filtering by date.

It doesn’t look like that’s an out-of-the-box option.

Depending on the license of the geofinder module, (and/or permission from Natural Logic), an adjustment to their module may be in order to support this feature.

We could also explore running the geofinder search from PHP and sorting the results… but I’m not sure if that would be supported by their code either.

Hi jonparadise2,

I am going to move this on over to the Community Help Forum. It seems like the community is already reaching out with some great advice. Thanks Mark!

If you have any questions about ExpressionEngine specifically, please let me know by opening a new thread!

Have a great week guys!

Cheers,