Hello,
I have a content template that shows events from the events calendar plugin
I am trying to add a Query filter to only show current events as it is showing past events too.
Custom field filter
_EventStartDate is a number greater than or equal TODAY()
I tried the above but it didn't work.
Hi,
Thank you for contacting us and I'd be happy to assist.
The '_EventStartDate' suggests that you're using the Events Calendar plugin.
That field doesn't store the date/time value 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, you can add a new 'Event Start Date' field in the custom field group 'Extra Event Details', 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.
regards,
Waqar