This thread is resolved. Here is a description of the problem and solution.
Problem:
Client has start date and end date custom fields. In a custom search View they have added filters for the begin and end dates, but would like posts to be included in the results if any part of its dates overlap with the filter start and end dates.
Solution:
The trick is to compare the start date from the filter with the end date of the post, and the end date from the filter with the start date of the post.
Insert filters for the start and end dates. In the Query Filter section (you may need to use the Screen Options tab at the very top of the page to expose it) edit the filters to swap the URL parameters used by the two filters, and to make it so the the start AND end filters must be true.
Relevant Documentation:
https://toolset.com/documentation/user-guides/filtering-views-query-by-date/
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| - | 7:00 – 14:00 | 7:00 – 14:00 | 7:00 – 14:00 | 7:00 – 14:00 | 7:00 – 14:00 | - |
| - | 15:00 – 16:00 | 15:00 – 16:00 | 15:00 – 16:00 | 15:00 – 16:00 | 15:00 – 16:00 | - |
Supporter timezone: Europe/London (GMT+00:00)
I don't think it is a bug. It is finding the right settings. When there is a product available from 1 april until 31 oct. So I want people to be able to find this when:
-they search in a range from 1 jan 2018 until 1 jan 2019 (then the product will be in between the dates)
-they search from 31 march until 7 april
-they search from 28 oct until 5 nov
Si this is what I want to be able to
Cheers
Hi Nigel,
So sorry. Didn't read it and probably jumped to conclusions! I am graving for some rest :-).
I set this now but when I search from 5 april to 26 april it is not showing me anything. Why? I don't get it anymore. The tour is available from 1 april tot 31 oct it should be there shouldn't it?
