I am trying to: to add a custom field filter to a view query (content selection)
The filter is on a Start Date field (type DATE) condition is Greater Then TODAY, produces zero results, but I have data that has events with future start dates, so the result is wrong, therefore not working as excepted.
This is my filter: Select items with field: Start date is a DATE greater than TODAY()
Link to a page where the issue can be seen: hidden link
I expected to see:
Two events that have the start date set to the future dates.
Instead, I got:
no results.
Also, when I change the custom field filter from Greater Than to Greater Than and Equal to TODAY(), then I get all the results, where there only be 2 events that match this criteria.
Hello. Thank you for contacting the Toolset support.
Unfortunately - the access details you shared with your first reply is somehow not accessible.
Can you please share bit more details what view you created and on what page?
*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.
I have set the next reply to private which means only you and I have access to it.
The thing is that Toolset Types custom date field value stored as Unix Timestamp to database.
So, I've adjusted the query filter for the Event Start Date as given under:
Custom field filter
Select items with field:
Start date is a number greater than or equal NOW()
