This thread is resolved. Here is a description of the problem and solution.
Problem:
Posts have start and end dates.
Client wants a custom search View to be able to specify start and end dates as a between filter so that if there is any overlap between the range of start-date to end-date of the posts and the filtered date range then posts should match and be displayed.
Solution:
You need to compare the end date of your filter with the start date of your post and the start date of your filter with the end date of the post.
So a partial overlap of the posts and the filters being applied would be achieved if
- the post end date is later than the filter start date (the post hasn't already finished when our filter period starts), and
- the post start date is earlier than the filter end date (the post doesn't begin after our filter period is over)
Insert the start and end filters as normal, then edit them to swap over the URL parameters that provide the filter value.
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.
No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.
| 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)
This topic contains 2 replies, has 2 voices.
Last updated by 5 years, 5 months ago.
Assisted by: Nigel.
I am trying to: I have a custom post type with a "Start Date" and "End Date". I'm using a search filter for both start and end dates.
Here's the query filter:
Select items with field:
Start Date is a number between URL_PARAM(wpv-wpcf-start-date), URL_PARAM(wpv-wpcf-end-date)
OR
End Date is a number between URL_PARAM(wpv-wpcf-start-date), URL_PARAM(wpv-wpcf-end-date)
Here's the Search screen
<label>[wpml-string context="wpv-views"]Sale Start Date[/wpml-string]</label>
[wpv-control-postmeta field="wpcf-start-date" type="date" default_date="TODAY()" url_param="wpv-wpcf-start-date"]
<label>[wpml-string context="wpv-views"]End Date[/wpml-string]</label>
[wpv-control-postmeta field="wpcf-end-date" type="date" url_param="wpv-wpcf-end-date"]
Link to a page where the issue can be seen: You have access from an earlier post to hidden link
I expected to see: When I search on a date that is actually between the Start and End date (e.g. I set Sale Start Date and End Dates to Jun 22, 2019), I see events that start or end on that date, but there's an event that spans from Jun 21 to Jun 23, and this event doesn't show up on the results screen.
The images show two events, both span Jun 21 -Jun 23. When I search on Jun 22 start and no end date, it shows both. When I search on Jun 22 as both start and end date, it shows neither.
