I am trying to setup a view to display the next upcoming event from Events Calendar Pro, I have found a number of other threads with the same problem however the solution defined is not working for me. I have created a view following this exact method: https://toolset.com/forums/topic/view-ignoring-the-event-start-date-field/
The problem I am facing is that I am seeing no results found, when setting to less than it shows me all events (even future ones) and greater than returns nothing. I have gone as far as checking what query is actually being executed, and running it in phpMyAdmin works as expected.
Please let me know what else I can to to fix the problem, as I believe what I have done should work fine.
Thanks.
hidden link
Hi,
Thank you for contacting us and I'd be happy to assist.
The other support thread that you're referring to is very old and a number of changes have been introduced to WordPress and the involved plugins, since then.
The date fields from the Events Calendar plugin don't store the date/time values in a UNIX timestamp format ( ref: hidden link ) which is a universally standardized way.
The Toolset's date-type custom fields and the date/time filters also use and expect the date/time values to be in the same format. Due to this difference in format, this date-type filter is failing.
To make this work in a safe and consistent way, you can add a new 'Event Start Date' field using Toolset Types, which will be a 'Date' type field, and store the start date in this field too, for all the events.
Then you'll be able to use this new date field for date/time filters, in the views.
regards,
Waqar
